Strange thing happened on compaction

  • Thread starter Thread starter DungeonAccess
  • Start date Start date
D

DungeonAccess

Howdy,

I compacted my database and it seemed like everything went fine, but when I
started to do more testing, my OrderID #s went back to 1. I have been
testing for a while so #1 actually happened a long time ago and has actually
been deleted since then. What the heck happened? Has anyone seen this
before. Also, I had a temp table that I guess Access created with an error
in it. The error was that it could not find the field "Description" on
compaction. I believe that is what it said. I didn't make a note and the
table has already dissappeared. Do I have gremlins in my box or is this
common with Access? Any clues?

Thanks,
DA
 
Ok, I was able to look at a MDB file that I saved right after that happened.
I thought I had better have a copy pronto in case something bad was about to
happen. Here is what I gathered from the table that was in the backup:

MSysCompactError - the table name

Fields:

Error code= -1504

ErrorDescription= Can not find field "Description"

ErrorRecid= null/blank

ErrorTable= Orders

I guess I'll have to do more research on this. I'm still fairly new to
Access, and this is definitely new to me! I'll welcome any feedback.

Thanks,

DA
 
Back
Top