sql tables deleted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Bret said:
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
Click to expand...

Add a Timestamp column to your table on SQL Server.
 
Back
Top