multiple users

O

owilson

Hi,

I have a database that on a server for a compnay wide
intranet and would like to allow more than one user ar a
time. As it is now, only one user can use it at a time.
It is located on a shared drive where each user has full
permissions.

Is there something special I need to do to allow multiple
users?

TIA

Owen
 
6

'69 Camaro

Hi.

At least one of your users is opening the database without adequate Windows
security permissions, thereby locking the other users out of the database.
For information on several methods of guaranteeing multiuser access to
Access databases, please see the following Web page for a link to the
article, "Multiuser Databases":

http://www.Access.QBuilt.com/html/articles.html

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
A

Arvin Meyer

Make sure that the database is split with everything but the data is on each
workstation. The data should reside in a database on the server, linked to
each front-end. Then make sure that each individual doesn't open the
database exclusively.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
6

'69 Camaro

Sorry. I didn't read your statement fully about the "Full permissions," so
the database needs to be checked for "open in exclusive mode" first, as
Arvin and Joe mentioned. If you find that all users really are opening the
database in shared mode though, then you'll need to re-check the Windows
security permissions for the users, because it's _very_ common for Windows
Network Administrators to give "Full permissions" to most of the users, but
forget about people who joined the group later.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Top