Table MSysAccessStorage Opened Exclusively by Another User

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just deployed a new Access DB to multi users which requires each user to
logon. One user, after logging on, gets the message "The table
'MSysAccessStorage' is already opened exclusively by another user, or it is
already open through the user interface and cannot be manipulated
programmatically." He can't get into the database! No one else is having
this problem. Help!!
 
The MSysAccessObjects table is the Access 2000 (and earlier) object, while
MSysAccessStorage is the Access 2002 object. Was this database converted
from Access 2000 to Access 2002? Also, is this a replicated database? There
is an article regarding this in connection with replication
http://support.microsoft.com/d­efault.aspx?scid=kb;en-us;2823­68


--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html
 
Yes, I believe I did convert this DB from Access 2000 to Access 2002-2003. I
never knew how it started out in 2000 format... It is not replicated
(because I'm not familiar with replication). It is accessed by multiple
users on a network drive. I read the article you attached; since the DB is
not replicated, I assume it does not apply to this DB(?). Thank you. -
Rhonda
 
Lynn said:
The MSysAccessObjects table is the Access 2000 (and earlier) object,
Click to expand...


No, that one started with Access 2000. It is not in Access 97 or
earlier.

Cheers,
TC
 
I believe there was something wrong in the registry. We re-imaged the
machine, and now the DB works perfectly. THANK YOU for your help! - Rhonda
 
Back
Top