MySQL Forums
Forum List  »  Microsoft Access

Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
Posted by: George Loeppky
Date: April 29, 2005 04:02PM

After much trial and error, I realized that simply refreshing the link to a table only works as long as you aren't changing any indexes. Particularly if you don't have a Primary Key setup and Access asks you which fields are the unique identifier.

In general a good rule of thumb would be to remove and relink tables if you are changing any indexed fields or fields that are used by Access as a unique identifier.

George

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: ODBC - insert on a linked field - [microsoft][ODBC Driver Manager] SQL data type out
2858
April 29, 2005 04:02PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.