Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Foreign Keys interfering with viewing Tables in Access?


Message #1 by "Alex Hanson" <alex@t...> on Mon, 24 Feb 2003 17:51:30
I introduced Foreign keys for Declarative Referential Integrity to my 
database which is a Access 2002 Front end to a SQL Server 2000 backend. 
Now I am unable to browse the contents of those table in the Access 
Window. I can see them in Enterprise Manager so I know the data exists. 
What can I do to examine tables in the Access Project Explorer? I keep 
getting errors such as " "PrimKey[My Primary Key column]" is Read only", 
or "The Stored Procedure was run Successfully but no rows were returned"

Thanks for any Help

Alex

  Return to Index