2 hours
ago: Doing some maintenance on the server today. If you've placed an order and it hasn't processed yet, hang in there. Should be ready soon. I've got the car up on the jack and the tires are off...
Dismiss
I have a split database with four tables in it. One of the tables shows that the data is read-only. I cannot make any changes to the data in this table. How can I correct this so I can make changes again?
Sounds like corruption. (Compact/Repair), or something went haywire with the linked table. Remove and then relink it. I read somewhere that that can happen.
This can happen for a few reasons. First, check that the back-end database file isn't marked read-only in Windows and that you have full read/write permissions to the folder it's in. Also make sure no one else has the back-end open in Exclusive mode, as that will make it read-only for everyone else. Sometimes the link itself just gets messed up, so try running Compact and Repair on both the front-end and back-end, then delete and relink the table. A brief network hiccup can also cause Access to open a table read-only until you reconnect.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Forum.
