Error when opening db

[Chaplain Doug]

Access 2002. This error just started happening. When I
try to open the database (HDH.mdb), and another user has
it open I get the following error 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.

I notice that when the db comes up under these
circumstances I can see the tables and the queries, but no
forms, reports, or modules show up. What gives?

P.S. I posted this in the "Setup & Configuration" section
as well. I know, I know only post in one place. But some
categories seem to get better attention than others.
Sorry.

 

[Cheryl Fischer]

Doug,

Have you tried creating a new empty database and importing all of your
objects from the problem db to the new one? The only KB article I can find
that appears to relate to your problem is the following (and it's
questionable):

http://support.microsoft.com/default.aspx?scid=kb;en-us;810415

 

[Guest]

i TRIED THE DB RECREATE AND THE PROBLEM PERSISTS. The
error also sometimes also says:

The table 'MSysAccessObjects' is already opened
exclusively by another user, or it is already open
throught the user interface and cannot be manipulated
programmatically.

AS WELL AS,

The table 'MSysAccessStorage' is already opened
exclusively by another user, or it is already open
throught the user interface and cannot be manipulated
programmatically.

 

[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/default.aspx?scid=kb;en-us;282368

 

[dreamingwombat]

I got this error with Access 2003 purely by replicating a database an
storing it in the same network folder.

I deleted the copy and all is fine


-
dreamingwomba