receiving error "id" is not an index in this table error 3800.

  • Thread starter EveryCreatureCounts
  • Start date
E

EveryCreatureCounts

When trying to access a table in a exsisting database, I get a error box
stating "id is not an index in this table. Accessing the help button for
this error. The statement of Error 3800 is displayed. Does anyone know how to
clear this up? Is it a failure with Access or the state of the database?
 
J

John W. Vinson

When trying to access a table in a exsisting database, I get a error box
stating "id is not an index in this table. Accessing the help button for
this error. The statement of Error 3800 is displayed. Does anyone know how to
clear this up? Is it a failure with Access or the state of the database?
Click to expand...

This "is not an index" error means that your tables are corrupted. MAKE A
BACKUP IMMEDIATELY (don't overwrite any older backup, you may need it!). See
http://www.granite.ab.ca/access/corruptmdbs.htm for a discussion of database
corruption, its causes and cures.

If you've been generous to strangers, kind to stray cats, and otherwise
accumulated some good karma, you may be able to use Tools... Database
Utilities... Compact and Repair. If that doesn't solve it check out the
remedies in Tony's website above.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Active Content in this file is blocked issue 1
Index Not In This Table - Error 3800 6
Insert Index into a Table 1
id is not an index in this table 3
Office add-in registration error - Component not correctly registered 0
error 3800 id invalid 1
"Compile error in table level validation expression " after format 0
Setting column width in a table with a macro is not working 0

Top