Linked Views

I have linked to some SQL Views in my Access FrontEnd. The first time I link to the Views it asks for the Primary Key and I select one. If I refresh the links using the Linked Table Wizard in Access, they seem to loose what I have set as the Primary Key. Is there any way around this?
Thanks!You have two options:
--Don't use the wizard. Link in code (you'd programmatically delete
the old links and create new ones).
--If you want to use the wizard, delete the old linked views first,
and relink them from scratch.
--Mary
On Fri, 18 Jun 2004 13:24:02 -0700, Deb
<Deb@.discussions.microsoft.com> wrote:
>I have linked to some SQL Views in my Access FrontEnd. The first time I link to the Views it asks for the Primary Key and I select one. If I refresh the links using the Linked Table Wizard in Access, they seem to loose what I have set as the Primary Key. Is there any way around this?
>Thanks!