multiple database users on a network

[pkeegs]

We have a five PC network with all files located on a server PC. Our network
will only allow our Access 2003 database to be accessed on the server PC and
one other slave(?) PC at the same time. Is this normal or is there a setup
which will allow all PC's to run the database at the same time?

Regards

 

[John W. Vinson]

We have a five PC network with all files located on a server PC. Our network
will only allow our Access 2003 database to be accessed on the server PC and
one other slave(?) PC at the same time. Is this normal or is there a setup
which will allow all PC's to run the database at the same time?

Regards

You should... must, I'd say!... use a split application, with the Tables in a
shared "Backend" on the server, and with each user having their own copy of a
"frontend" containing the Forms, Reports, and code, with links to the backend.
See http://www.granite.ab.ca/access/splitapp.htm for a thorough discussion of
the technique.

 

[Arvin Meyer [MVP]]

Access should never be run from a server unless it is a Terminal Server, or
a web server that uses a browser, instead of an Access front-end. The proper
way to run Access on a network is to split the database and put the table
database on the server linked to each user with a copy of Access and the
database front-end on each workstation. There is a wizard to do this:

Tools >>> Database Utilities >>> Database splitter

or you can easily do it manually. See, Tony Toews' FAQ on the subject:

Splitting the database:
http://www.granite.ab.ca/access/splitapp/overview.htm

 

[Stefan Hoffmann]

hi,

We have a five PC network with all files located on a server PC. Our network
will only allow our Access 2003 database to be accessed on the server PC and
one other slave(?) PC at the same time. Is this normal or is there a setup
which will allow all PC's to run the database at the same time?

Access/Jet tries to create a lock file (*.ldb) when accessing a database
file. This may fail for consecutive users when the permissions are wrong.

btw, does every user has its own local copy of the frontend?

http://support.microsoft.com/kb/304932


mfG
--> stefan <--

 

[pkeegs]

Our database is split and it makes sense to have just the backend on the
server - will try the frontend on each computer and see what happens - thanks
for the advice and link