Table MSysAccessStorage Opened Exclusively by Another User

[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!!

 

[Lynn Trapp]

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

 

[Guest]

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 Trapp]

Well, you may have some kind of corruption, because I've only seen that
table referenced in connection with a replicated database. You might try to
import all the objects from your database into a new database.

--
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

 

[Jeff Conrad]

The information I have been reviewing also suggests making
sure you have the latest Jet version. It will not hurt anything
to try this.

How to obtain the latest service pack for the Microsoft Jet 4.0
Database Engine:
http://search.support.microsoft.com/?scid=kb;en-us;239114

--
Jeff Conrad
Access Junkie
Bend, Oregon

in message:

 

[Lynn Trapp]

Good idea, Jeff.

--
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

 

[TC]

The MSysAccessObjects table is the Access 2000 (and earlier) object,

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

Cheers,
TC

 

[Guest]

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

 

[Lynn Trapp]

I'm glad you got it working.

--
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