Stop changing paths for linked tables?

[twgonder]

Windows 11, Access 2021

I'm getting a mini demo ready. I'm not sure where the demo users will place the Access files.
One file is the .accde, the other is a log file as an .accdb.
I went to the Linked Table Manager and put in a path that would say the log file is in the same directory (using "." as is normal in paths) where Access is starting.

It looks like this:



If I close and reopen the data base, it looks like this (back to the full path on my PC, not where the user will put it!):





Anyone know how I can get Access to stop doing this? Or know of a valid workaround?
(It seems like I spend a lot of time working around Access boneheads like this, no other DOS/Windows application I've worked on does this kind of crap. Put in a path, use the damn path, stop overwriting it.)

Obviously, I don't want demo users to have to go into the Linked Table Manager just to run a small demo.
(I know, short-term, I could pull the linked tables back into the .accde, but that just kicks the problem down the road. This will be an ongoing install problem unless fixed.)

[Gicu]

Usually you would have code in the Autoexec macro or the start-up form's Open event to relink the tables by setting the .Connect property of those table(def)s to CurrentProject. & "" & "YourDbLogName.accdb"

https://stackoverflow.com/questions/...ogrammatically

Cheers,

[twgonder]

@Gicu, post #2 Thanks for that. I'll go read.
But I'm curious why we would need code to do something the link manager is supposed to do? Hmmm

[twgonder]

A final note before I mark this solved. The article in post #2 was helpful. The "solution" required some tweaking in that I have more than one extermal .accdb that I could be linking too, which most anyone should plan on too.