Multi-user questions for MS Access

A

Asurada

If I made an database file from MS Access and put the file in the Windows
Server, will users can access and update that database file at the same time ?

Thanks for your reply in advance.

With best regards,
 
D

Douglas J Steele

Yes, out of the box Access databases are multi-user.

Note, though, that it's strongly recommended that you split your application
into a front-end (containing the queries, forms, reports, macros and
modules) and a back-end (containing just the tables). Only the back-end
should be on the server: each user should have his/her own copy of the
front-end, preferably on their hard drive. This significantly reduces the
risk of database corruption.

Note that each user will need to have Read, Write, eXecute and Delete
permissions on the folder where the back-end database resides. This is
because a locking file (.LDB) is created there when the first user connects
to the database, the locking file is updated by subsequent users, and
deleted when the last user releases the database.

There's a built-in splitter wizard in all versions of Access, although it's
fairly simple to do manually. See what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm
 
A

Allen Browne

Yes, they can.

We strongly recommend that you split the database, so that each user has
their own copy of the front end, while they share the back end data.

More info:
Split your MDB file into data and application
at:
http://allenbrowne.com/ser-01.html
 
L

Larry Linson

Asurada said:
If I made an database file from MS Access and put the file in the Windows
Server, will users can access and update that database file at the same
Click to expand...
time ?

In addition to the good advice you received from Douglas and Allen, there is
an overview presentation on Access in a Multiuser Environment in the
Downloads section of http://appdevissues.tripod.com and the best, in detail,
collection of information and links on multiuser that I know about is at MVP
Tony Toews' site, http://www.granite.ab.ca/accsmstr.htm.

Larry Linson
Microsoft Access MVP
 
T

Tom Wickerath

Hi Asurada,

Here is an article that you might find helpful:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/multiuser_applications.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

If I made an database file from MS Access and put the file in the Windows
Server, will users can access and update that database file at the same time ?

Thanks for your reply in advance.

With best regards,
 
Top