Delete in Access table fields for SQL Server Linked tables

S

Sue

I am linking tables from a SQL Server 2000 database to an
Access 2000 database. On the Access side, one table shows
the records correctly but the other tables show #Deleted
in each field of every record. I can display the fields
on a form and I can add records. If I move off of a
record in the form, the fields now show the #Deleted on
the form. I get the same results in the linked table,
queries, or forms. I created a View on the SQL Server
side and linked the view but I get the same result. I
created a DSN using Windows authentication for the linking.
 

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

Doughnut Chart linked with the slicer in the pivot table 0
Adding data to MS Access from csv file 0
Help creating a search form in Access XP 0
Table Security in Access 2013 1
Setting column width in a table with a macro is not working 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Linked SQL Tables don't report Cascading Updates and Deletes 2
Access 2013: Form problem in reading data tables; relationship one-to-one 0

Top