linked table returns #Deleted records

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

Guest

I have an Access 2002 database linking to many tables in a SQL Server 2000 database. The application has worked successfully for several months but now three or four linked tables (out of around 50) are returning '#Deleted' data in every field of every row.

The only change identified is that two new users have been added to the SQL database.

Thanks in advance for any suggestions.

regards

Trevor
 
Have you tried re-linking the Tables?

--
HTH
Van T. Dinh
MVP (Access)



Trevor Mills said:
I have an Access 2002 database linking to many tables in a SQL Server 2000
Click to expand...
database. The application has worked successfully for several months but now
three or four linked tables (out of around 50) are returning '#Deleted' data
in every field of every row.
 
Back
Top