Access Project and SQL

[Jimmybaz]

Hi, I am using access project to connect to a sql 2000
database. I have created a form in access 2000 to edit
the records through a view. The problem is that in the
view if I try to edit the record i get an error: "record
set requires a form to be updateable". When I attach the
form to the view I get "form is read only, because the
unique Table property is not set". The view has two
tables joined if I remove one I can edit the record but I
need both so the user can see the selection. I don't know
what else to try. Any help is and will be appreciated.
Thanks

JimmyBaz

 

[Kevin @ 3NF]

Wild guess here, but do both of the underlying tables have a primary key
defined?

 

[Jimmybaz]

They both have primary keys...

-----Original Message-----
Wild guess here, but do both of the underlying tables have a primary key
defined?

--
Kevin Hill
3NF Consulting
www.3nf-inc.com/NewsGroups.htm






.