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?

Do the tables have primary keys? 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.

-Sue

On Wed, 19 Nov 2003 12:21:45 -0800, "Andrew Agbay"
[quoted text, click to view]