MSDE View with JOIN Read-Only

  • Thread starter Thread starter Barry van Dijk
  • Start date Start date
B

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?
 
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
Click to expand...
Only.
 
Back
Top