Linked Table Cant Delete Record

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
 
A

Armen Stein

Try RE-linking to the SQL Server... that would be remove the link and
recreate it and see if you get the same behaviour.

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
 

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

Top