Link table losing primary key

[craig322]

I have a problem with linked tables. I have no problem creating them with a primary key so that the tables are updatable. We have login restrictions to the database that forces me to change my password every 90 days. When I change the password (because I have my password set in the odbc connection) I must relink the tables. When I relink the tables, I lose the primary key. This only happens when I choose a primary key when linking the table, not for an access defaulted primary key.

Does anyone know how I can either prevent this from happening or how I can readd a key without dropping and recreating the link.

TIA

 

[dhookom]

I'm not sure why you are losing the primary key. If the table has a primary key then Access should be able to identify it.

You can create an run data-definition queries to create virtual primary keys. The SQL would look something like (I think):

CREATE UNIQUE INDEX PrimaryKey ON tblYourTable (fieldname)

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]