Database suddenly read-only

ColinEssex

ColinEssex

Old registered user
Local time
Today, 21:17
Joined
Feb 22, 2002
Messages
9,451
I have a database running for the last 6 or so years (A97) and have the ctl-shift disable enable code in it to stop people tinkering about with it.

The database was aparently working fine yesterday and today it's decided to be read-only so no-one can update the data.

It's on a server - all permissions ok and not read-only.

I can't get the disable/enable code to work either. So basically, it's locked for any development changes and it's locked for any data changes.

The IT boys are going to take a backup from the tapes of the server and re-install it, so it should be ok, but I've never had this happen before and the database is used daily for the last 6 years with no problems.

Any speculative thoughts?

[edit] I have done a search and couldn't find anything that fitted the situation

Thanks

Col
 
Has somebody tweaked the mdb file itself. View in Explorer, right click select properties and make it Read Only.

Just a thought

L
 
speculative thoughts
Althoug you say "It's on a server - all permissions ok and not read-only"
Favorite reason would be permissions not OK. May be something has changed on the server.

I had a case where XPPro was serving a db and all of a sudden it went read only, I checked permissions and all appeared OK. Rebooted server PC and everything started working OK.

HTH
 
failing that - how about create new d/base and import everything in (tables first) compli - then the rest - see if this solves it - had the same problem couple of years ago - not sure how i solved it - but I did in the end
 
Ask if a recent patch was done to the server that involved the MDAC code or that involved macro security.

One of the issues that get you every time is a patch that includes a tiny little policy change to the security code. For instance, WinXP Service Pack 2 just about KILLED any unsigned .DLL files. If you whack the DLL by making the associated objects read-only, there you are.

Also, an issue that you need to consider is that YOUR group's permissions might be OK, but is there a chance that someone dinked with some OTHER group's permissions in a way that spilled over to accidentally include you?
 
Another idea: if there is a user total file-size limit/quota on the server, and the db (combined with other files on the server) has grown to reach this limit then new records will mysteriously not be saved. It has happened to me before.
 
Just to say thanks to the contributors here - most of the suggestions I'd tried but appreciate your thoughts.

Our teckies have re-installed the Db from the backup discs and all seems well now.

Thanks chaps

Col
 
DrSnuggles said:
Out of interest what was it?
Click to expand...

I have no idea - sorry. I can't work out why / how / or by whom it happened. I'm pleased the backup is ok and not much data was lost. I can't get into the database construction to see.

As long as our Medical Secretaries are happy thats the main thing

Col
 
Oh, crud, yeah! Keep the secretaries happy. The bosses think they run the place, but it is their secretaries / admin assistants that do the REAL work.

Just like Chief Petty Officers run the Navy and Coast Guard and the Sergeants run the Army, Air Force, and Marine Corps. Let the officers live in their blithe ignorance and not bother the chiefs and sergeants.

Back to the real world: Colin, one bit of "Old Programmer's Rules" - problems that go away by themselves come back by themselves. Be on the lookout for a recurrence. Yes, it is good to know that your backup works. It would be BETTER to know why you needed it. So if there is ANY WAY IN HELL to debug it if it happens again, I strongly recommend it.
 
You must log in or register to reply here.

Similar threads

J
Read Only Message
Replies
6
Views
268
Gasman
Gasman
V
Code that worked suddenly started throwing errors?
Replies
10
Views
460
Pat Hartman
P
G
Solved Tantrum time ...Run time error91
2
Replies
32
Views
670
Gasman
Gasman
A
Solved Access Database Locking Issue
2
Replies
31
Views
1,119
Ajay289
A
R
Database inconsistent
Replies
9
Views
476
gemma-the-husky
gemma-the-husky

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom