Lose ability to add records after refreshing linked tables

[Guest]

I am building a database in access that has the backend on a Sql 2000 server.
Whenever I refresh the tables in Access I lose the ability to add a record
to any table. I have to delete the link and manually reconnect using my ODBC
DSN. Once I recreate the link I can add records to the tables. I have never
seen this before. Any suggestions on how I can stop this? Thank you!

 

[Rick Brandt]

I am building a database in access that has the backend on a Sql 2000
server. Whenever I refresh the tables in Access I lose the ability to
add a record to any table. I have to delete the link and manually
reconnect using my ODBC DSN. Once I recreate the link I can add
records to the tables. I have never seen this before. Any
suggestions on how I can stop this? Thank you!

When you create the links manually are you prompted to select columns that
constitute a unique index? If the table on the server has no primary key or
unique index then you should get that prompt and the information you provide in
that prompt is required to do updates. If you later refresh the link that
information is lost. The best solution to that is to add a primary key to the
table on the server (since all tables should have one anyway).

 

[Guest]

Rick,
Brain freeze on my part. That fixed it. Thank you.