'MSysAccessStorage' error in split database

[avagodro]

I have an Access Database that I am running over a Novell Network. It has been working fine, without any errors or problems. The database is a split database (non-replicated) in Access 2002 format.
When a couple of the users attempted to use the database simultaneously today, the second user encountered an error message, which I have been unable to find any answers to.
The message is "The table 'MSysAccessStorage' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically."
Does anyone know what this means, and how to correct it? I tested it myself this evening by opening the database on one computer, then loading it on mine, and I did not see the error.
Any help, thoughts, or suggestions would be GREATLY appreciated.

 

[avagodro]

I believe that I have found the issue that is causing this. I found it in the Microsoft Knowledgebase, Article ID 810415 - Database bload is not stopped by compacting database with Access 2002 format.
According to the article, the symptom: "If you have a database this is in Access 2002 format, database bload occurs when you repeatedly add or remove large numbers of objects that contain code. You cannot stop the database bload when you compact the database."
The cause: "Records are added to the MSysAccessStorage system when objects that contain code are created and the project is then compiled. Some of these records remain when the objects are deleted. These records are not removed when the database is later compacted."
I have followed one of their methods for the workaround, which is "If possible, develop the database by using Access 2000 format. Then, when the database is ready to deply, create a new Access 2002 format database and import all the objects from the Access 2000 format development database to the new Access 2002 database." but when I attempt to create an MDE database file, I receive an error that states that Access was unable to create the MDE file.
Any suggestions?

 

[PHV]

In order to successfully create an MDE file the following conditions (at least) must be meet:
1) Access file format = access version
2) The database must compile properly

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[avagodro]

Thank you. I had completely forgotten about compiling the VB Code. That worked, and I was able to publish my update before people get in and start needing to use it.