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)?
 
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)?
Click to expand...

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...
 

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

Similar Threads

Date() and Access 2007 Runtime 15
Runtime 2007 and Linked Table Manager 2
Access 2007 Runtime and Action Query Notices 6
linked tables 2007 <--> 95 4
Stupid Nondescript Runtime Errors 3
Is it possible to split access database with runtime or by vba code ? 1
Access 2003 --- Access 2007 Runtime Conflict 8
Access 2007 Runtime and linking to back end and printing 6

Top