Back End Only Opening Read Only

CPGDeveloper

Board Regular
Joined
Oct 8, 2008
Messages
174
So this has happened now 2 days in a row --

I administer an Access DB with 12-15 users -- each user has an .accde copy of the front end on their desktop and the back end is on a shared server.

I got a call saying that all of a sudden nobody could add a new entry to the db. I look into it and for some reason I can only open the Back End Read Only. I ensure that nobody is in the db and there is no laccdb lock file. But still, I can only open the back end read only.

I make a copy of the back end -- make that the new back end db, and re-write everything to link to the new back end. I give all the users the new version and everything works fine.

The next morning, the same issue happens again. I again made a new back-end, etc.

Any ideas on what this is and how I can prevent it in the future?
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
I would look at the properties for the file and see if it has been set to read only?

If so, are the other files in the folder also set.?
Is some process running that sets all files in folder to read only.?

First test is the actual file itself.?

HTH
 
Upvote 0
Likely one or more users does not have the correct permissions on the be folder. Everyone must have full permissions otherwise they cannot delete or edit the lock file. If they cannot delete, a user can still open but put the db in a read only mode (or is it "exclusive"?). Last user out deletes lock file, but the db is "locked". Don't forget that a folder can inherit permissions from a parent folder, so that can be part of the problem as well (i.e. users may have the requisite permissions but the folder may have a limitation imposed from upstream). You might check to see if there is a command line switch for "shared" so that you can open the be with it, but I don't think so. You might be able to create a small db utility that will reset the be property back to shared. I have never done that, but I have altered other db properties with such db's.
 
Upvote 0

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top