I am sure that this must have been asked before, but I cannot find it.
Can I set the relative path for the location of the linked table in Access 2003?
Another table is also saved in the mdb file. These databases will sometimes connect via odbc or oledb, so relying on the vba code that runs when the Access file is opened will not work. If possible, I would like the "partition" of the database to be invisible to plug-ins, and not to check the correct tables each time.
Edit due to comments:
To explain more clearly; in this case, I mean a set of interconnected access databases that are all in the same directory.
If they are copied as a group, all links will work, but until they are updated, they will indicate incorrect data. If , I open the mdb file in Access, a simple vba macro can check and update the links if necessary. The problem is that in the current setup, databases are connected to much more often by other programs (via oledb / odbc) than by opening them in Access .
Question: do I need to manually start the update every time I move the mdb files, or is there some way to either A) make the links relative, or B) initiate the check when creating the connections?
Since the purpose of this is to partition an existing database, I do not want to modify the connection programs to run these checks, if this is not necessary, so this is the question.