Corrupt database

[John Baker]

I have a database used by about 10 people across a network, with the _be on
the server and the _fe on each PC. The data file became corrupt with a
corrupt record in the main table. The record had the usual corrupt Chinese
characters in it. I deleted the record and compacted and repaired the
database and thought everything was going to be ok.

However I now find that queries that contain 2 or more tables which contain
the main table can no longer be used to allow the appending of a new record.
In other words they are no longer updateable queries. It probably didn't
help that I found out that I was using MSAccess 2000 with no service packs
installed.

Any suggestions to rectify the problem??

 

[Allen Browne]

John, you may find that the corruption caused Access to drop an index. That
can lead to a query going read-only.

If you have not already done so, run the compact/repair (Tools | Database
Utilities) on the back end. Then open the affected table, and check to see
if the primary key is still in place. Then check the relationships between
that table and others. Hopefully that will get you back up to where you were
before.

You are probably aware of the general pointers listed in:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html

 

[John Baker]

Thanks very much for your help Allen.
I seem to have fixed the problem by importing all the tables into a new
database. I then copied the structure of the main table and then used an
append query to append all of the records to the new table and then renamed
it to the name of the main table after deleting the main table. I then
performed a compact and repair.

All this probably just had the same effect as you described. It is all
working fine now.

Thanks again.
John.

 

[Tony Toews]

The record had the usual corrupt Chinese
characters in it.

This sounds like corruption is a somewhat frequent occurrence.

You may want to spend some time trying to figure out what's causing
the corruptions.

Determining the workstation which caused the Microsoft Access MDB
corruption
http://www.granite.ab.ca/access/corruption/workstation.htm
Corrupt Microsoft Access MDB Causes
http://www.granite.ab.ca/access/corruption/causes.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm