Recently I am facing a problem for linking SQL server table in Access2000. I Linked SQL serever using ODBC driver and was enable to link tables but i faced this following error for those tablae contains more than 10 Column
"A Unique Record Identifier Can't Consist of More than 10 Fields".
How can i solve it ? I need to select all fields from a table.Plz help me its an urgent