Multiple Users Connecting to Access Database

[Guest]

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

 

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

 

[Guest]

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

 

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

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

John W. Vinson[MVP]

 

[Albert D.Kallal]

To get you "up to" speed, I got a nice article that explains in detail why
you split, and some things to watch out for.

http://www.members.shaw.ca/AlbertKallal/Articles/split/index.htm

 

[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

 

[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