MSDE View with JOIN Read-Only

[Barry van Dijk]

I'm using Access 2000 as a front-end and MSDE as a back-end.

I've create a view, which consists of a table and another view.

In the enterprise manager I'm able to update and add records to this view.

In my access project (.adp) the view is read-only. (Not even creating a
form)

I tried creating a form and set the Unique Table property, still Read Only.

Any suggestions?

 

[Barry van Dijk]

Without a JOIN it works. So the fields I needed from my JOIN I've moved
to a User Defined Function, so there is no need for the JOIN anymore.

I'm using Access 2000 as a front-end and MSDE as a back-end.
I've create a view, which consists of a table and another view.
In the enterprise manager I'm able to update and add records to this view.
In my access project (.adp) the view is read-only. (Not even creating a
form)
I tried creating a form and set the Unique Table property, still Read

Only.