ID is not an index in this table

[Guest]

One day it was working fine and then hte next day my database won't work and
keeps coming up with the error message:

"ID is not an index in this table"

Unfortunatley it does not say which table or what the error is. Has anyone
seen this error before? and how can you correct it?

Thanks

 

[Jeff Conrad]

in message:

One day it was working fine and then hte next day my database won't work and
keeps coming up with the error message:

"ID is not an index in this table"

Unfortunatley it does not say which table or what the error is. Has anyone
seen this error before? and how can you correct it?

Hi Bill,

This does sound like some form of corruption. While the corruption *could*
be one of your tables, it could also be a System table, in which case you
do have big problems. I would make several backup copies of your database
right now and then review the following links on corruption. Perhaps this
information will get you back up and running.

http://allenbrowne.com.au/ser-47.html

http://www.granite.ab.ca/access/corruptmdbs.htm

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Whittle,Jerry
(See Fix Corrupt Access Database v3.9 Document)

http://www.e-tech.ca/001-AccessFAQ.asp

http://www.everythingaccess.com/tutorials.asp?ID=0

ACC2000: How to Recover Data from a Corrupted Table by Using the DAO Method
http://support.microsoft.com/?id=815280

ACC2000: How to Troubleshoot Corruption in a Microsoft Access Database
http://support.microsoft.com/?id=306204

ACC2000: How to Troubleshoot and Repair a Damaged Jet 4.0 Database
http://support.microsoft.com/?id=209137

ACC2000: How to Recover Data from a Damaged (Corrupted) Table
http://support.microsoft.com/?id=247771

ACC2000: How to Use MS Query to Recover Data from a Damaged Jet 4.0 Database
http://support.microsoft.com/?id=304561

Jetcomp utility available at:
http://support.microsoft.com/?id=273956

Good luck,