sql tables deleted

[Bret]

I have a linked SQL table to my Access frontend.
My process purges the SQL table source data thru a pass thru Access query.
Then it appends an Access table back into the linked SQL table.
Problem is when I do this all the fields and cells read "#Deleted, no data
has appended. When I go to to SQL to view the source table, it has all the
data there, its just not displaying in the linked table. Please why does
this happen and what can I do to remedy this?

thanks in advance

 

[Rick Brandt]

I have a linked SQL table to my Access frontend.
My process purges the SQL table source data thru a pass thru Access
query. Then it appends an Access table back into the linked SQL table.
Problem is when I do this all the fields and cells read "#Deleted, no
data has appended. When I go to to SQL to view the source table, it
has all the data there, its just not displaying in the linked table.
Please why does this happen and what can I do to remedy this?

thanks in advance

Add a Timestamp column to your table on SQL Server.