Copy access database

A

Amduke

Hello,

I'm develloping a new database. In this database there are several tables
linked.
After completing the database with forms and querys, I like to let other
users use my database.
The problem is, when I copy the database from my local enviroment to the
network, the querys wont work anymore due to incorrect linked tables.
How can this be solved.

Thank you.
 
A

Arvin Meyer

The best way is to put the data on a UNC share:

\\ServerName\FolderName\FileName

and link to that from your local front-end. Then give everyone a copy of
that front-end. Failing that, make sure everyone has the same drive
mappings. That can be done with the login script, or manually at each
workstation.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
J

John Vinson

Hello,

I'm develloping a new database. In this database there are several tables
linked.
After completing the database with forms and querys, I like to let other
users use my database.
The problem is, when I copy the database from my local enviroment to the
network, the querys wont work anymore due to incorrect linked tables.
How can this be solved.

Thank you.
Click to expand...

Just to add to Kai's and Arvin's suggestions, there is a tool built
in: Tools... Database Utilities... Linked Table Manager. This will let
you reset the links to the backend.

It will need to be rerun on every desktop which has a different drive
letter for the backend's directory, which is one very good reason to
use the UNC link Arvin suggests.


John W. Vinson[MVP]
 
Top