Deleted records in MS Access reappear

[scott.tang]

I'm experiencing a very strange problem. My application is MS Access
front-end and MS SQL server back-end database. I have a SQL statement
that deletes records from a table after an export process. The
problem is occasionally when the delete statement is executed, these
records no longer display on List Box (not even in the MS Access link
table). But when close and reopen the form, those records reappear.
It almost like MS SQL server rejected or reversed my SQL command. Any
help is greatly appreciated.

Scott

 

[Mark A. Sam]

Scott,

Are you using A2007? I have seen that in a popup datasheet, but when I
closed and reopend the DB is cleared up. Also I don't get a confirmation
message, the records just delete. It may be a quirk in the program.

Also open the table and try to enter and delete a record manually. If you
don't have a timestamp field or primary key you will have a problem. I have
had trouble with SQL Server tables in the past and have had to remove
primary keys, reesatblish them and relink tables.

God Bless,

Mark A. Sam