Reply to thread

Message: [QUOTE="Rick, post: 2543940"] Hi, I have an Access 2k app I am deploying which has a front end backend design, but there are some "local" back end tables that sit on the users workstation. All of the front end and local backend files are contained within one folder. By default, the front end looks for these local back end tables in the C:\myfoldername directory. However, some users may need to put their folder in the H: or G: drive. The only way I know to re-establish the links is to have them run the Linked Table manager. I'd like to automate a proceedure so they don't have to do anything at all. I've been told Access doesn't use relative paths (which would work great in this scenario) and I was pointed to a code sample at an mvp site that is supposed to check to see if links are established, but even that code prompts users to choose a location. Any thoughts? Thanks, -Rick [/QUOTE]