RefreshLink Method (DAO.TableDef)

[hans]

Hi,

I link to SQL server tables from Access. On startup I
automatically set the ODBC DSN-less connections for each
table by setting the connect property for each one.

I then need to call the table.RefreshLink Method. Problem
is that as i do this I lose all primary key definitions
that were selected when linking the tables in the first
place.

Because of this, I now cannot add data to the tables, they
are basically read only.

Any ideas on how to avoid losing the primary key defs
when calling RefreshLink?

Thanks Hans

 

[Douglas J. Steele]

Take a look at http://members.rogers.com/douglas.j.steele/DSNLessLinks.html

I show one way to determine what you'd previously set the key to.