ODBC links & Primary keys

J

John Smith

In A97, when you create an ODBC link to a view, Access asks you to specify the
primary key column(s). Unfortunately, if you then refresh the link with the
linked table manager, Access kindly forgets this and makes the table not
updateable.

Does anyone know a way of either:
Refreshing the link without losing the key definition, or
Putting the key back afterwards without having to re-link the table from
scratch?

Thank-you
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Linking Files and Select Unique Record Identifier 2
Setting the primary key when using DoCmd.TransferDatabase acLink 3
Setting Primary Key on a Linked SQL Table 4
Form and subform weirdness when linking to SQL Server 2005 via OD 2
ODBC linked table - primary key 11
Link between forms when the child field is part of the primary key causing crashes when creating new 0
ODBC Connection failed. Newbie question. 0

Top