cannot update ODBC tables

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

I have an access database which have some linked tables
to SQL server.

But I found the tables data cannot be updated.

It seems read only.

How can I make the tables updateable?

Thanks in advance
 
Hi Ann,

Do you have permission to update the underlying SQLS tables or views? If
views, are they updatable?
 
when I opened the ODBC linked tables in Access, it asked
for SQL server login, I logged in by using sql systmem
admin and tried to update the table, but I cannot.

I do all the above operation on a workstation which is in
the same workgroup with SQL server.

Thanks for any suggestions




-----Original Message-----
Hi Ann,

Do you have permission to update the underlying SQLS tables or views? If
views, are they updatable?


I have an access database which have some linked tables
to SQL server.

But I found the tables data cannot be updated.

It seems read only.

How can I make the tables updateable?

Thanks in advance
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
It sounds as if you don't have update permission on your tables. Ask
your database administrator for help.

when I opened the ODBC linked tables in Access, it asked
for SQL server login, I logged in by using sql systmem
admin and tried to update the table, but I cannot.

I do all the above operation on a workstation which is in
the same workgroup with SQL server.

Thanks for any suggestions




-----Original Message-----
Hi Ann,

Do you have permission to update the underlying SQLS tables or views? If
views, are they updatable?


I have an access database which have some linked tables
to SQL server.

But I found the tables data cannot be updated.

It seems read only.

How can I make the tables updateable?

Thanks in advance
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Back
Top