Multiple Users Connecting to Access Database

G

glenno

Hello,

I am using Access 2000 and have a database that is centrally located in a
shared folder on the network that has full read and write permissions open.
If one user is connected to the database from their machine then no other
user can open the shared folder in Windows Explorer and double click on the
database to open it. They must start Access and then use file->open to
access the database. Why is this and can this behavior be changed? Thanks...

Glenn Olsen
 
D

Dean

In this scenario, only one user will be able to update data because the will
be opening the file exclusively. You should split the database into a
Front-end and backend, and put copies of the front-end onto each users
computer, with back-end on the server. Each user will then have independent
accesst to the data. There is a Database splitter wizard to help you do
this.
 
G

glenno

Dean,

OK, I have split the database, but when I move the front end to another
machine the path to the back end is not right and I can not find where to
change it. Can you point me in the right direction? Thanks...

Glenn
 
J

John Vinson

OK, I have split the database, but when I move the front end to another
machine the path to the back end is not right and I can not find where to
change it.
Click to expand...

Tools... Database Utilities... Linked Table Manager

John W. Vinson[MVP]
 
L

Larry Linson

You can relink tables using the Linked Table Manager -- on the Database
Window Menu, Tools | Database Utilities | Linked Table Manager. Obviously,
you have to have access to the disk where the tables database resides, and,
not so obviously, you have to have full permissions to the folder, including
create and delete permissions.

Larry Linson
Microsoft Access MVP
 
D

Dean

The Access Developers Handbooks, by Getz, Litwin and Gilbert contains sample
functions to verify links and perform relinks in code. This approach is very
useful if you want to develop linked to one backend and then deploy front
ends that connect to production backends
 
Top