[thelist] Problems with deleted records in Access

Luther, Ron Ron.Luther at COMPAQ.com
Tue Nov 7 07:50:39 CST 2000


Hi Oliver,


Yeah ... sometimes keeping a 'deleted' field is a good idea... but it isn't
always required!

However, the only guess I have for your problem is that maybe you are not
closing the recordset after the deletes ... before doing the new inserts....

Pretty lame ... but it's the only guess I have this early in the day!

HTH,


Ron L.

-----Original Message-----
From: Oliver Lineham [mailto:oliver at lineham.co.nz]
Subject: [thelist] Problems with deleted records in Access

Deleting the records was fine, but when a new record was added later one or 
two of the deleted records reappeared.  I deleted them again, but the 
reappeared again when more records were added.




More information about the thelist mailing list