link a table using virtual path instead of hard coded path?

[Infiltrator64]

I want to make my database portable so a user can put it in any folder they would like. I will have a folder called Database that they will always run the database from however I don't care where they put it on the local or network drives.

I simply want it to look in the folder that the database was opened in for any links.

I currently have one table I need to link to which will be in the Database folder. The only way i can figure out how to link it is with a fixed path of c:\database.

Can this be done? Something like %path%\Database

 

[sweater_vests_rock]

infiltrator.

if your users are always running the database from the folder containing your link, could you use CurDir or ActiveWorkbook.Path?

ben.

 

[Infiltrator64]

sweater_vests_rock


That sounds like what I want to do however I'm not sure how to do it. When I link a table I browse to the file location. I don't know how to edit the path so it starts in the current directory instead of looking for a hard link like c:\database.

I just started to use and learn access yesterday so I obviously am a rookie with access and may need to be guided by the hand initially.

 

[sweater_vests_rock]

infiltrator.

I'm talking about commands in the VBEditor. Ignore my ActiveWorkbook.Path -- that is an Excel command. However, CurDir will return the folder which contains your database.

So, if you are linking via VB, you can use the value CurDir returns to guide you to the folder containing the database and the linked table. Because I don't use Access, I'm not sure if there is a way to do this outside of VB.

Ben.