ADP and SQL

[Ravi]

I am connected to a SQL Server via ADP. I cannot update a
view with two tables, only one. I need to have two tables
so I can see what I am updating. Any help with being able
to update a view with two tables is greatly appreciated.
The err I get when I try is" recordset requires a form to
be updateable". When I attempt to do it through a form, I
get, "Form is read only because the unique table property
is not set". I don't understand because both tables have
their primary keys defined.

Thanks,

Ravi

 

[chas]

Hi Ravi,

A view based on multiple tables in SQL Server is by design
non-updateable. Using the View as the basis of a Form in
Access is OK as long as you set the UniqueTable property
of the Form to the name of ONE table in the View that you
want to update data in.

Open the Form in design view, choose View>Properties and
scroll the list until you find 'Unique Table'.

hth

chas