#Delete

  • Thread starter Thread starter Jeff G
  • Start date Start date
J

Jeff G

Hello Everyone!
I have been getting “#Delete†in every field between ID 1541 and 1542 in
my Table. I can delete the line by selecting the deleting it, and ACCESS even
asks me if I'm sure I want to delete it. The problem is this; It deletes’,
but when I close the table it comes back (same line). I can’t delete the
information in the fields themselves, nor can I overwrite them.
I did create a new blank database and export the data into it (this I'm
told, is supposed to eliminate corrupt data) I can use the database all day
long and the #Delete's are not there. However, the next morning when I come
in and use the database guess what? It magically appears between the same ID
lines (even the ID line has #Delete in it!!!).
Now my backup database is just fine, but I'm also not using it. It is
strictly for back up. I do my backup on the first of each month, I create a
new blank database and import the data into it and name it Maintenance
Database Backup 01 May 08.MDB etc, etc...
Does anyone have any idea what could be happening?
 
Have you run a Compact and Repair?

How about a C&R using the JetComp program?

Instead of exporting to a new database, create a new database file and
import into it.

See what is going on at night time that could cause such a problem.
 
Yes I have run compact and repair. I have no idea what a C&R using the
JetComp program is? But I think I may have solved the problem of it magically
reappearing every night. It seems that our server has been replicating
somehow (there were 9 databases named db1, db2, db3 etc...) and all those
databases were non-corrupt. Not sure why they were being replicated, (suspect
a network problem thru our server which contains the database for sharing)
either way, I'll find out tomorrow morning when I open up the database. We'll
see......
 
Back
Top