I need to allow all others read-only access to an Access database while it is open and being updated by another user.
It is currently updated by opening it in Access with no other front-end.

Read-only connections may use ADO.

Thanks

Durwood

You may start by looking at the help on the record locking choices. The Tools/Options menu, Advanced tab is the user interface to the settings.

Your question is vague in that it gives no indication as to whether you need all tables locked even if an unrelated table/record is being edited.

Record lock information is maintained in the file with the same name as the database but with an extension '.ldb'. Various tools exist for reading/interpreting the lock file information but it is not trivial. The read only connections can use this information to open non updatable recordsets based on lock file indications.

Alternately, you can set a flag record if you use a form interface (on dirty) to the data and use your ADO access to query the flag record/table and provide appropriate access.

Ciao
Jürgen Welz
Edmonton AB Canada
[email protected]

I only need to lock one table. I need to be able to display information on a web page even if the table is being edited. As it is now, If the table is open for editing the "in use . . ." error is given.

Thanks for your assitance
Durwood

Sounds like optimistic locking is called for. You may want the web ADO recordset to look at a clone of the table that is being updated if records are continually being updated.

Ciao
Jürgen Welz
Edmonton AB Canada
[email protected]

I would like to replicate but it may prove unecessary as I specified (we are using DSN on this connection) the connection as read-only.

We shall see.

DSN has nothing to do with how you lock a record



Sal