Access Locking issue

  • Thread starter Thread starter Matthew
  • Start date Start date
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
 
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
 
Back
Top