how to terminate a remote shared microsoft access session

  • Thread starter Venugopal Chakkoth
  • Start date
V

Venugopal Chakkoth

Hi...

I am a beginner in Microsoft Access.

I have an access application that is used by 70 different users at the same
time... It works fine most of the time but it gets locked at times and no one
will be able to update the records.

Please let me know if there is any chance to figure out the system that has
locked the records and is there any way that we can remotely kill that
particular session.

Please let me know.

Thanks
Venu
 
J

jahoobob via AccessMonster.com

Did you split you database? Are all 70 users opening the same database or
are they opening 70 different ones linked to a back end? If not, then
splitting your database should alleviate the problem. Type split in Help and
look at "Split an Access database (mdb)" and "About sharing an Access
database on a network (mdb)" to find out how to do this.
If it is already split, you would need to check that any instance of the db
locks only edited records. Tools>Options>Advanced>Default record locking and
make sure that Edited record is checked.
 
Top