Read Only Table

Z

Zachary Turner

I was entering data into a DB i created, then all of a sudden I
noticed that one of my tables had become read only. I don't know what
I did to make this happen, but now I'm unable to add any records to it
or change the value of any existing fields. Can anyone give me a hint
as to what might be going on?

Thanks
 
A

Arvin Meyer

You possibly have 1 or more rows of corrupted data. First copy the entire
file as a backup, then copy each of the tables to a new database. If you
cannot copy the corrupted table, try and open it and copy the records until
you find the bad ones. Then delete and recreate the bad record(s)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Z

Zachary Turner

I finally figured it out. Not what was causing it, but at least how
to fix it. I looked at the table in design view and I had a primary
key based on 3 fields. I removed the primary key, and then deleted
one of the fields. It gave me a message that it was going to have to
delete a bunch of indexes as well, so I said ok. At that point, the
table was editable. I added the field back, then went back and filled
it in. Went back to design, recreated the primary key, and now
everything seems to work fine. Not sure what might have happened.
 
Top