problems with shared access

O

Orion

A user is complaining that since the Upgrade of our server from
Windows 2000 Server to Windows Server 2003 he cannot access his MS
Access Database file if someone else is using it at the same time.

Where can one set a database to be used by a single user only or by
various users at once?

Thank you.

Norbert
 
A

Arvin Meyer

Typically, that's set in: Tools ... Options ... Advanced ... Default open
mode

You may also have a problem with sharing (and corruption) if you database
isn't split so that only the shared data is on the server and each user has
a copy of the front-end (code, forms, etc.) on his workstation.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top