If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
CORRUPTION???
Hi all
If you have a corrupt record somewhere in a data table, how do you find/eliminate it? My tables have relationships on key fields that are autonumbers. I believe that this will make creating new tables a nightmare as auto numbers would reset on recreation. Help!! |
#2
|
|||
|
|||
CORRUPTION???
On Tue, 6 May 2008 22:22:44 +0100, "Derek" wrote:
My tables have relationships on key fields that are autonumbers. I believe that this will make creating new tables a nightmare as auto numbers would reset on recreation. What you can do is create the new table (in a new .mdb file!), empty, and run an Append query from the linked corrupted table. The existing autonumber values will be copied into the new table. Just be sure that the append query omits any reference WHATSOEVER to the corrupt record. For instance, if you ascertain that the record with autonumber ID 3124 is corrupt, use a query with criteria like = 3123 AND = 3125 so that you never "touch" the corrupt record. -- John W. Vinson [MVP] |
#3
|
|||
|
|||
CORRUPTION???
On May 7, 5:22*am, "Derek" wrote:
Hi all If you have acorruptrecord somewhere in a data table, how do you find/eliminate it? My tables have relationships on key fields that are autonumbers. I believe that this will make creating new tables a nightmare as auto numbers would reset on recreation. Help!! Hi, You may also try to recover your file. You can try a tool called Advanced Access Repair at http://www.datanumen.com/aar/ This tool is rather useful in salvaging damaged Access MDB files. Hope this helps. Alan |
Thread Tools | |
Display Modes | |
|
|