I have an Access database that links to a set of tables in a SQL7
database and performs updates. This works fine as long as there is an
"Identity" column in the SQL7 table. But we have some databases out
there at a few of our customer sites where the tables do not have an
identity column. It works there as well as long as the tables are
linked manually an the user indicates the correct column as the
primary key column. But we provide a "refresh" function that cycles
through the tables and reconnects all of them with code. In that case,
the tables all become not updatable. Is there a way in the code to
specify the key column?

Zack Sessions