This database has been opened read-only

[supmktg]

I'm running an mdb in 2007 and it is running in read-only mode. The read-only mdb has attached tables in several external mdbs on the network. I think I have determined that the read-only issue is being caused by the network folders that contain the external mdbs.

I am not a network guru, nor do I fully understand 2007 "Trusted" settings. But, as a test I moved one external mdb to a folder that was successfully functioning with a completely different 2007 application. While in that other folder, I successfully ran an update query on a table in that moved mdb. Before I moved it, the update query failed (read-only error).

To check my theory, I created a brand new test accdb with attached tables in one of the working folders and one of the non-working folders and got the same result. The table in the working folder updated, while the table in the non-working folder failed.

Can someone explain how, where, why, etc. to correct the settings on these other folders or within Access to eliminate this read-only issue?

Thank you very much,
Sup

 

[GinaWhipp]

Is this database split? Have you checked the folder permissions?

 

[boblarson]

You need to make sure that everyone who is going to use the database has read/write/delete permissions on both the frontend folder and backend folder.

 

[supmktg]

Folder permissions was indeed the problem. The network permissions on the 2 folders being used by the app have been changed to full permission for everyone on the network and read-only is gone for everyone.

The confusing thing for me was that when I opened the app, it was not read-only. This was because I was the one who created the 2 new folders, so I guess I automatically had full permissions.

Thank you very much,
Sup

 

[supmktg]

Now, we have a sharing issue. When the FE (currently located in a network folder) is opened by one user, a second user cannot open it, either from a shortcut or by navigating to the app on the network. They double-click and nothing happens. The FE mdb is set to shared, as is the BE mdb and everyone has full permissions on the network folders. If it makes any difference, the app was created in A2K and running in 2007

I know sharing a FE is frowned upon, but I would like to allow it at least until I'm done tweaking the app. The database is split, so everyone will have their own front end once I'm done making changes.

What have I missed that is blocking the second user?

Thanks,
Sup

 

[GinaWhipp]

Sounds like it's opening in Exclusive Mode which will automatically happen if you open in Design Mode (Access is smart like that). I will recommend splitting now... At the very least give everyone else their front end to share and you keep one to make changes. Then every night (or morning) drop in the updated one...

 

[supmktg]

Thanks GinaWhipp

 

[GinaWhipp]

You're welcome...