Linked Table Manager (v2000)

Topic

New Reply

I have SQL tables linked in Access and they work fine.
However, if I run the linked table manager on the SQL
tables, I am informed that the links refreshed. When I
open the tables, they are read-only. If I delete the
tables and re-link them, they work fine again.
Any ideas why this occurs?
Thanks!

Reply | Quote

Replies

I’m not sure that I followed your situation 100%, but perhaps the SQL SERVER permissions on your tables are set to read-only – ie. only SELECT, not UPDATE, INSERT, or DELETE?

Reply | Quote

Thanks Taibe,

I found the following info to explain why:
When you first attach the
tables and if you specify the unique identifier for the
table, this information is stored in Access. If you refresh
the links, the information you specified for the unique
identifier can be lost. So you either need to have a primary
key on the tables or refresh the links programmatically and
specify the unique index.

Reply | Quote

I know this is a very late response but…
Thanks for the info! I think it may be relevant to a problem I’m having now – see post 390571

Reply | Quote

Thanks TJ!

Reply | Quote

Thanks TJ!

Reply | Quote

I know this is a very late response but…
Thanks for the info! I think it may be relevant to a problem I’m having now – see post 390571

Reply | Quote

Thanks Taibe,

I found the following info to explain why:
When you first attach the
tables and if you specify the unique identifier for the
table, this information is stored in Access. If you refresh
the links, the information you specified for the unique
identifier can be lost. So you either need to have a primary
key on the tables or refresh the links programmatically and
specify the unique index.

Reply | Quote

I’m not sure that I followed your situation 100%, but perhaps the SQL SERVER permissions on your tables are set to read-only – ie. only SELECT, not UPDATE, INSERT, or DELETE?

Reply | Quote