Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database Converted to Read Only

Status
Not open for further replies.

Garridon

Programmer
Mar 2, 2000
718
US
I created a duplicate database for another user.&nbsp;&nbsp;While I was gone for two weeks, she went in and used it normally.&nbsp;&nbsp;Yesterday, when she opened it up, it told her that she couldn't modify anything--that it was read only.&nbsp;&nbsp;I tried going into it as well with the same result.&nbsp;&nbsp;I checked the properties, but read only isn't checked.&nbsp;&nbsp;She called the help desk, but no one can figure out why it did this.&nbsp;&nbsp;Any thoughts? <p>Linda Adams<br><a href=mailto:Garridon@aol.com>Garridon@aol.com</a><br><a href= Adams Online</a><br>I'm a professional writer, published internationally.
 
You have to determine if that's an Access message or OS message. If OS you can check to see if anything has been changed as far as your OS security or the OS file attributes. Here's a real ususual thing thats happened once to me in version 2.0 or 97. Turned out somehow the OS file attributes were reset to Read Only. If you just right click on the file you can check - only Archive should be checked. And here's the wierdest part&nbsp;&nbsp;only Archive <i>was</i> checked, but I had to turn it on, then turn it back off again. For some reason it was not displaying the actual status.<br><br>
 
Check the properties for the form under Data, make sure the RecordSet Type is set to Dynaset, not snapshot.
 
It looks like it's a network problem.&nbsp;&nbsp;The database is stored in a shared directory.&nbsp;&nbsp;I copied back onto my hard drive, and it worked just fine.&nbsp;&nbsp;Tried copying it back, and I got a copy error message (I tried copying other files; same thing).&nbsp;&nbsp;At least it's not the database itself!<br><br> <p>Linda Adams<br><a href=mailto:Garridon@aol.com>Garridon@aol.com</a><br><a href= Adams Online</a><br>I'm a professional writer, published internationally.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top