Access Locking issue

M

Matthew

There are currently several webpages that were created in
Access that query info. in the database.
There is also an employee who needs to periodically
add/update the database.
The problem is that when someone is viewing the webpage
that queries into this Access DB, the DB itself can
only be opened in read-only mode.

Is there a way to allow the webpages to view data,
and still allow the DB to be opened normally?

Any help would be greatly appreciated,
Thanks
 
H

Hugh N. Ross

Make the viewing operations open the table as a recordset in shapshot mode.
The user that is editing the table should then be able to modify records.
Look up the help about locking.
I hope this helps. Hugh
 
Top