Can you define a primary key to a linked table ?

[BillDickenson]

I'm linking to a table in another Access DB. But when I was running tests, it took longer than it should have. I realized it is effectively sweeping the table for each match. So I tried to define a primary key and it won't let me. Any way this can be done ?

 

[alvechurchdata]

You have to close the database you're using and open the mdb which holds the table to which you are linked. You have to be the only person using that table before Access will let you modify the structure.

Geoff Franklin

http://www.alvechurchdata.co.uk