I'm pretty stumped on this.
I have two db (supervisor and client)
some of the tables have to be synced between them.
In the past I used a mysql table on our host, but this time I cannot do that.
Syncing will have to happen through a tumbdrive (usb key)
Each db has linked tables to a db called sync.
I have macros in each db to take or give information to the sync db.
However, I cannot control whether or not the drive letter for the sync db will always be the same, or the location the same, and don't know how to be able to have the 'linked table manager' find it.
Does anybody know a way to code a "find sync db".
Basically, I'm hoping to have the same type of popup window as a 'save file' or 'open file' window.
Have my user point to the 'sync db'
Have linked tables point to that automatically,
and run the rest of the macro or code.
I've tried a couple on the internet (http://www.mvps.org/access/tables/tbl0009.htm
but couldn't get that to fit my needs.
Any help would be greatly appreciated.