Linked Table Cant Delete Record

  • Thread starter Thread starter James
  • Start date Start date
J

James

I created a linked table in ms access 2003 to a sql server
When I open up the linked table in datasheet view I cannot delete any records.
Yet if I open up sql query analyzer I can delete all the records from the
table, so I do not think it is a rights issue. I never had this problem.
could it be something with the odbc connection to the sql server? Or any
other ideas.
Thanks
 
Try RE-linking to the SQL Server... that would be remove the link and
recreate it and see if you get the same behaviour.
Click to expand...

Yep, good thing to try. Also, can you *edit* those records in Access?
If not, then you probably don't have a unique key identified in
Access. You should be prompted for it when you create the link.

Armen Stein
Microsoft Access MVP
www.JStreetTech.com
 
Back
Top