sql server connect: I have a several tables in a SQLServer database, all of which have primary keys defined. When manually linking to three of those tables with MS Access, I get prompted to provide a Unique Record Identifier as if there was no primary key defined. Arrrrgggg! I am trying to automate a process to rebuild the links each time the database is opened and when linking programmatically (deleting and re-creating the tabledefs) the resulting linked tables are not updatable. Anyone with a clue?

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/

With the three Tables that you are having problems with,
are the names of the "Primary Key" fields in use as other
Primary Keys on other Tables? E.G. Are you use "RecordID"
as a Primary Key Field on more than one Table?

If you are then this is the problem. Re-name your fields
in SQL Server so that all fields are unique. This should
then sort out the Problem in MS Access.

HTH


Tony C.
[quoted text, click to view]
which have primary keys defined. When manually linking to
three of those tables with MS Access, I get prompted to
provide a Unique Record Identifier as if there was no
primary key defined. Arrrrgggg! I am trying to automate a
process to rebuild the links each time the database is
opened and when linking programmatically (deleting and re-
creating the tabledefs) the resulting linked tables are
not updatable. Anyone with a clue?
[quoted text, click to view]