Deleted records in MS Access reappear

S

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
 
M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Using DSUM to get running total on a filtered form 0
MS access login issue 3
Access Access 2010 import/append data into table w/o overwriting existing records 0
Access 2010 append query to SQL is very slow 0
Not able to add or edit records from an input form. 3
Accent in MS Access 2
Cannot delete records in subforms 2

Top