Missing Index

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I created the a table with a 3 field index as part of the Primary Key.
On a daily basis run from a macro, all data from the table is deleted, then
an append query is run to insert the new data. Duplicate data is not appended
as per the key. The database is running in Access 2003.

The index just disappeared and I had to recreate it. It was been running
fine since the recreation. Has anyone ever encountered this situation?

The index looks like this:

cus_no Text Length 12
acct Text Length 14
acct_no Text Length 14
 
Is the data deleted or the table dropped then recreated?

If deleted, possibly the database is corrupt. Try a compact and repair.
 
All the data is deleted first, so it is empty. Then the append occurs. The
database is usually repaired and compacted weekly.
 
That is strange. Short of someone else messing with the indexes, it almost
has to be a corruption issue. You might want to import everything into a new,
blank database file.
 
Back
Top