linked table returns #Deleted records

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
 
V

Van T. Dinh

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.
 

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

Copy Access tables to Access Project with SQL Server tables 5
Can't link to MS SQL Svr 2005 table (#deleted) 8
Conneting to SQL server, Need advice 3
Linked SQL-Server data not visible (imported data fine) 2
Linking vs Importing using ODBC connected database 1
Linked Table Manager works one at a time 4
Invalid Argument Error when importing .csv to Linked Table 1
Duplicate Records in Access 2000 linked to SQL 2000 1

Top