Linking Access with ODBC

[alex]

Hello experts,

I have a question regarding linking a table in Access.

I go to FILE; GET EXTERNAL DATA; LINK TABLES. I then choose ODBC
Databases and link my chosen table.

During the process I'm asked to Select a Unique Record Identifier
(you can select up to 10).

When I select only one unique identifier, my data appears to duplicate
on particular rows and other data isn't select at all-the more
unique identifiers that I choose, the more accurate my data becomes.
The problem, however, is that I have more than 10 fields in my table.

Can I only link tables with <= 10 fields or am I doing something wrong?
Thanks for any help.


Alex

 

[bazoorg]

when access does not what column is the primary key, it asks you to
identify it.

If you know what the primary key column(or combination of columns) is,
select these and you should get an accurate data.

i have not come across any limits on the number of columns in a table u
can link to

 

[Rick Brandt]

Hello experts,

I have a question regarding linking a table in Access.

I go to FILE; GET EXTERNAL DATA; LINK TABLES. I then choose ODBC
Databases and link my chosen table.

During the process I'm asked to Select a Unique Record Identifier
(you can select up to 10).

When I select only one unique identifier, my data appears to duplicate
on particular rows and other data isn't select at all-the more
unique identifiers that I choose, the more accurate my data becomes.
The problem, however, is that I have more than 10 fields in my table.

Can I only link tables with <= 10 fields or am I doing something
wrong? Thanks for any help.


Alex

If you only need read only access then just press Cancel on that dialog. If
you DO select columns then you must accurately select columns that will not
have duplicates. Otherwise any edits you make can affect more than the one
row that you are intending to update so don't just guess. Any yes, if you
select incorrectly you can also see duplicate data show up in your linked
table that isn't really there.