form lock up

C

CAM

Hello,

I am using Access 2002 my users are having some trouble with their forms it
seems that they cannot push any command buttons or move to next record or do
anything within their form. Many of the users open other programs, excel,
word, and other software. Many of them may have 5 or 6 programs open up,
but the other programs don't lock up only Access. Access only seems to lock
up an hour later. I did not code any time out session in Access. Can
anyone help me. Is there something in Access that I am not aware of or is
a net work issue? Any tips will be appreciated. Thank you in advance.
 
J

jahoobob via AccessMonster.com

Is your database split? That is, does each user open a unique copy of the
database or are they all opening the same database. If they are doing the
latter, that may be the source of your problem and splitting the database
should cure the problem. Also, check that All records is not checked on the
Advanced tab of Options. You probably want Edited record checked. Also,
check Open database using record-level locking.
Hope this helps,
Bob
 
Top