I am updating a program for several locations with a new version. The data table did not change, so I want to send the new version to them without the data table and have them import the table from the old program. They are not Access savy, so I need the code to ask the user to point to the file location where the program is at (path will be different at each building).
I agree with Paul that your really should split your application into a front end and back end.
I always split every database. It has so many advantages. Even fo a single user application.
An option you might consider is having teh front end auto link to the back end in the same folder. This way when you deploy an update, all you have to do is place the updated front end in the same folder as the back end. when the front end options, it can automatically relink to the tables in the back end in the same folder. The user will not have to do anything with this method.