Permission Question on External Linked Tables

  • Thread starter Thread starter Ocsom
  • Start date Start date
O

Ocsom

Greeting all; I link via ODBC to a SQL Server table using the sa login
(database owner) and I open the table. I want to randomly delete records
in the datasheet but somehow I do not have the permission ..

Using the right-mouse-click, I ger the context sensitive menu and the
Cut/Paste/New Record/Delete Record is greyed-out. Can someone help me
understand what I need to do in order to have full access to the data (SQL
Server table).

Thank you !
 
hi,
check to see if your odbc link is read only.
with our SQL server, one needs the readwrite password to
edit the tables in the SQL server.
 
Hmm .. my dsn utilizes the 'sa' account/pwd into the SQL Server .. Is
there something that I'm missing here ? How do I check if the ODBC link
is read-only ?

Thanx so much for your quick response !
 
Is a primary key defined for the table? ODBC links are read-only unless
there's a way to uniquely identify each row.
 
Bingo .. ! This is exactly the explanation that I was looking for ! I
made the necessary changes to the SQL Server table and everything is just
fine now !!

Thanx again !
 
You must log in or register to reply here.

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

Linked Table Cant Delete Record 2
Linked SQL Tables don't report Cascading Updates and Deletes 2
Linked Tables and SQL Server permissions 3
Using ODBC Linked Tables 10
linked table from ACCESS 3
Linking ODBC Tables for Multiple Users 7
Error 3157: "ODBC - update on a linked table <table name> failed 4
linked tables read only 1

Back
Top