I said I would let you know what I found out about this issue. Here is Microsoft's list they sent me of things to look at:
quote:Before we begin, there are a couple of logistics I would like to make sure you understand that go along with this support offering. With the Web Response support offering you have chosen there could be a 24-hour response time after receiving information from you and phone support is not included as an option with this support offering. If this offering will not fit your needs please let me know as soon as possible and we can determine what may work better to fit your needs. Also, we are limited to provide technical support for several issues in just one incident. If you have several issues, it is better if you can open up some new cases so that our engineer can help you with them in a timely and manageable manner.
In your case you've indicated you are using Office XP with some Office
97's. You use Windows 2000 mainly, a few Windows 98 and Windows NT 4.0. Your network is Novell Netware V6. You receive the following errors:
"The table 'MsysAccessStorage' is already opened exclusively by another user, or is already opened through the user interface and cannot be manipulated programmatically."
We shall be working to resolve this specific issue through the course of the case. If I have misunderstood your concern please let me know.
Before we go any further, would you please help collect the following
1. Does the database reside on a Netware Server? We have seen the
exact same error message when the database is on a Netware Server. Our
customer has reported this issue to Novell, and Novell think it is
NetWare Operation System problem. If this is the case, I would highly
suggest that you contact Novell for more information.
2. MSysAccessStorage and MSysAccessObjects are system tables. We
would suggest that you turn off the "Show system objects" option in
Access so that no user will open these system tables in user interface.
You can go to Tools->Options->View to see the options.
3. Please make sure you have the latest Novell Client installed on all these client computers. We have seen database corruption issues and performance issues with old version of Novell Client.
4. Do you have the latest Jet Engine and Office XP service packs
installed on these computers? Please refer to the following article to
make sure all these computers have the latest patches installed:
5. It is not recommended that we use an Access 97 database in an
environment with both Access 2002 and Access 97 running. We would highly suggest that you run the database in a pure Access 2002 environment or a pure Access 97 environment.
6. For Windows 2000 computers, please make sure you have applied
Windows 2000 SP4, which handles Opportunistic Locking better.
We (our IS guys) came up with this that seems to be working so far:
quote:These steps are only for Novell Clients on Windows 2000 PC’s
Your computer will need to re-boot after this is completed
1.) Close all programs on your computer
2.) Right click on “My Network Places”
3.) Left click on Properties
4.) Right click on “Local Area Connection”
5.) Left click on Properties
6.) Double left click on “Novell Client for Windows”
7.) Left click on “Advanced Settings” tab
8.) Left click on “File Caching” in list box
9.) Change “Setting” drop down box to “Off”
10.) Left Click on OK
11.) Left Click on OK again
12.) Computer will re-boot.
Of course the 1-12 steps are for our setup & environment.
Here is our set-up as listed above:
We use mainly Office XP, but still have some 97's. We also mainly use Windows 2000, but still have a few 98s and NTs and our network is Novell (v6).
I wanted to pass along this info because 1.) I said I would, and 2.) If I had this issue, then someone else is sure to have it to. Now that we all have this information, maybe the next individual can get it resolved in a shorter amount of time....
Oh, and by the way, to Bob Bedell...as an update on the security you suggested we look at. I was hoping it was this that was causing the issue (because it would be an easy fix), but we gave several people all identical network clearance, and still had the issue.
If anyone has any questions or wants any more information on what all we did and looked at, please feel free to contact me!
The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!