How to open Jet 4.0 database in Read Write mode and deny others the ability to modify data?

[Adam Chester]

I am attempting to open a Jet 4.0 database in Read/Write mode such that my
connection is the only one that can modify the database (write data or make
schema changes, etc).

I need other applications and connections (particularly MS Access itself) to
be able to open the database for read-only purposes, as the database is
populated over (potentially) many hours and users need to get (reasonably)
up-to-date information from the database as it's populated.

I have tried using "Mode=Share Deny Write" however this prevents *my*
original connection from being able to write to the database.

Is there any way to accomplish this?

Many thanks.

- Adam Chester

 

[Arvin Meyer [MVP]]

Try using user-level security and allow all others to only read the data.
Have a look at the security FAQ:

http://support.microsoft.com/default.aspx?scid=KB;en-us;q165009
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access