Using Multiple Users with MS Access Database files

[ngmiller]

I maintain the Access databases at the hospital that I work at. Last weekend, our server went down. Computer Services got a new server and reworked the networking permissions. However, Access will no longer allow more than one user to open the database at a time. This is a problem because we always have multiple users that need simultaneous access. The default is still "Open Shared" and I checked to ensure that the databases are not being opened exclusively. However, the message that I do get when a second user tries to open the database is:

The table 'MSysAccessObjects' is already opened exclusively by another user, or it is already open through the user interface and cannot be manipulated programmatically. (Error 3008) -

I understand that this message usually comes up when I try to open a table that is already being edited elsewhere. I have the record locks set to "edited record". However, this is a system file, so I am hesitant to make changes in it unless I know exactly what I am doing. This is a problem that we have never had before but for some reason was created after our server went down. I don't know why something changed or if this table is absolutely necessary. I am unsure where to start to solve the problem.

 

[jadams0173]

It sounds like the DB may have became corrupt when the server crashed. I think a good starting point would be to import all of your tables, queries, reports... into a new access database. Is the DB split into a FE and BE?

JMHO

I tried to have patience but it took to long! -DW

 

[ngmiller]

For those that are wondering, I received this reply on another forum and it fixed my problem.

Try this:

It apparently is a problem between Access and Novell. File caching was turned off and it now works.

These steps are only for Novell Clients on Windows 2000 PC's. They may work for other OSs.

Turn off Novell File Caching as per Non-existent MsysAccessObjects Table

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 and you must let it reboot for the settings to take effect..

Look at this link as well:

http://p2p.wrox.com/topic.asp?TOPIC_ID=5120