Access Project and SQL

  • Thread starter Thread starter Jimmybaz
  • Start date Start date
J

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
 
Wild guess here, but do both of the underlying tables have a primary key
defined?
 
A view with 2 underlying tables in SQL2000 is not updateable. Refer to the
comments in the ADP and SQL post above for the workaround.
 
Back
Top