User is locked out

  • Thread starter Thread starter JZ
  • Start date Start date
J

JZ

A userB keeps getting the following error msg but has not
gotten this message in the past what could have change to
cause her the following:

Table MsysModules2 is exclusively locked by user 'Admin'
on machine '.....'

The machine number changes as those of us that were
working in the DB close out. UserB can not access the DB

HELP!
 
Hi.

Are OpLocks disabled on the network server? Please see Microsoft's
Knowledge Base article #296264 for more info:

http://support.microsoft.com/default.aspx?id=296264

Also, ensure that none of the users are making design changes to modules,
forms or reports while other users are accessing the database. Users making
these types of design changes in Access 97 and earlier versions need to open
the database exclusively in order to prevent file corruption. Later
versions of Access prevent users from making these changes when any other
user is also in the database, so it's not an issue.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top