Help with linking tables in Access

[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.

 

[Gates Is Antichrist]

If homey don't play VBA, read no further, since that is how I have dealt with this.

Classically an .INI file was used, initially seeded during the user installation process, to specify the "foreign" directory("folder"). Nowadays it seems that everyone has gone to using the registy, though I still think .INI is a fine approach(and IMNSHO far more user friendly, which we know runs contrary to the Microsoft dogma of obfuscation and removing simple capabilities from users, as Microsoft believes they are all children that only mess things up).

That's the relatively easy part. Then the .Connect property can be used in code to link. Is this a feasible track for you?