database on server

C

ChrisC

Hello,

can an Access database on a server (company server) be used by different
people at the same time (ie entering data, running queries, ...) or do you
have to do something special to acquire this?

Thanks,
Chris
 
D

Douglas J. Steele

Yes, out of the box Access is multi-user.

It's strongly recommended, though, that you split all Access applications
into a front-end (containing the queries, forms, reports, macros and
modules), linked to a back-end (containing the tables and relations). Only
the back-end should be on the server. Each user should have his/her own copy
of the front-end, ideally on his/her hard drive.

Tony Toews talks about how to split at
http://www.granite.ab.ca/access/splitapp/index.htm, as well as a free
utility to help you ensure that each user has the current copy of the front
end at http://www.granite.ab.ca/access/autofe.htm
 
A

Arvin Meyer [MVP]

ghetto_banjo said:
Access should work fine on a server with multiple clients using it.
Click to expand...

That is, providing it's split as Doug Steele mentioned. Database front-ends
which are shared are subject to corruption, they are also an administrative
nightmare since the admin usually must shut down the front-end to fix a user
problem, and if others are connected, corruption will often occur. The only
successful way to run an Access database as a multi-user application is to
split it and put a copy of the front-end on each user's workstation.
 
Top