Linked Tables and Access 2007 Runtime


D

Doug

I am developing a small Access 2007 application (single user) for a
non-profit organization. On my computer, both the front-end and back-end are
located in the same directory in my documents folder. The user is running
Access 2007 runtime (full version not installed on his PC). When he tries to
open the front-end database, he gets an error that says Access can't locate
the back-end tables - Access is looking for the files based on the directory
structure on my PC. How can I remove the physical path and simply tell
Access to look in the same directory (\application) or 1 level down -
(\application\data)?
 
Ad

Advertisements

A

Armen Stein

I am developing a small Access 2007 application (single user) for a
non-profit organization. On my computer, both the front-end and back-end are
located in the same directory in my documents folder. The user is running
Access 2007 runtime (full version not installed on his PC). When he tries to
open the front-end database, he gets an error that says Access can't locate
the back-end tables - Access is looking for the files based on the directory
structure on my PC. How can I remove the physical path and simply tell
Access to look in the same directory (\application) or 1 level down -
(\application\data)?

You're welcome to use our free J Street Access Relinker at:
http://www.jstreettech.com/downloads

It has an option called CheckAppFolder that will automatically and
silently relink to the back-end database located in the same folder.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
D

Doug

OK... I downloaded and copied the code over into a new module... how do you
use it? Am I supposed to call the function when Access opens the database?
How is this done?
 
L

Larry Kahm

Take a look in the Tables collection - and open the one called
ReadMe_JStreetAccessRelinker...
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top