cannot update ODBC tables

[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

 

[John Nurick]

Hi Ann,

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

 

[Ann]

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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.

 

[John Nurick]

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

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.