| | |
|
|
|
Access closes |
|---|
| message from =?Utf-8?B?YWNhcmxzb24=?= on 20 May 2004 |
In a database that I've been working on something weird haapens when I try to access a certain record number. If I try to view it the whole program shuts down. I tried to delete it using a delete query but it can not find the record. What is going on?
|
| Sandra Daigle replied to =?Utf-8?B?YWNhcmxzb24=?= on 20 May 2004 |
It sounds to me like you have a corrupt record - this can happen if there is
http://www.granite.ab.ca/access/corruptmdbs.htm
I have had this type of corruption once or twice and the way I was able to
resolve it was to create a copy of the structure of the table, then create a
query to append all of the data from the old table except the corrupt
record. After confirming that everything is ok, then rename the old table
(delete it later) and give the new table the name of the old one. Note that
you will also have to redo all of the relationships that were on the old
table.
Be sure that you make a copy of the entire db *BEFORE* you start trying to
salvage it. Keep a copy until you are sure you have resolved the problem. IF
all else fails, contact a db repair/recovery expert. Several are listed on
the above website.
Good luck!
|
|
Archived message: Access closes (MS Access)
