[AccessD] Corrupted Table

Hewson, Jim JHewson at nciinc.com
Thu Oct 2 08:49:22 CDT 2008


I developed a database in A2003 that was to be used in A2007.  I did
that because I do not have A2007 and the runtime is free.
I am waiting for my next company machine which will have Office 2007 on
it.
I noticed that the BE on the client's machine was beginning to bloat.
So I changed the BE to compact on exit and therefore when needed it
could be opened and closed in the runtime and it would compact.  I also
changed the FE to compact on close.
 
One form would not allow any new records - an error message would appear
that stated it would create a duplicate entry in an index.
I looked at the offending table and when I tried to enter data in the
table the AutoNumber PK would increment starting with a single digit.
There are over 150 records in the table.  So the next PK might be 7,
close the table, and try again.  It would increment to 8....
The first time, I created a blank mdb and inserted all the tables.
The second time, I copied the table - the copy works as expected.
 
What could be causing the table to corrupt?  Is the compact on close
corrupting the table?
 
TIA,
 
Jim
 
Jim H. Hewson 
 

################################################################################

This email transmission contains information from NCI Information Systems, Inc. 
that may be considered privileged or confidential and is intended solely for the 
named recipient.  If you have received this message in error, please contact the 
sender immediately and be aware that the use, copying or dissemination of this 
information is prohibited.

################################################################################



More information about the AccessD mailing list