Linked Tables and Access 2007 Runtime

  • Thread starter Thread starter Doug
  • Start date Start date
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)?
 
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
 
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?
 
Take a look in the Tables collection - and open the one called
ReadMe_JStreetAccessRelinker...
 
Back
Top