"Bill Strass" <wi******************@hotmail.com> wrote in message
news:b6**************************@posting.google.c om...
Problem: Access main form/subform as front end to SQL Server backend.
Add/edit via subforms work fine. Not so with main form.
Set up a master-detail form-subform using two
views linked from SQL Server. The subform allows inserts an updates,
while the main form will not.
The only solution I can think of is to
recreate using tables imported from SQL Server, so that the data is
all
local. This is despite the fact that the views in SQL are updateable.
The one updates while the other doesn't.
The only other obstacle I can
think of is that there may be too many joins on the main view (i.e.
12)
for the Access form to handle.
Any ideas would be welcome!
When you create a link to a view on a SQL Server, you should be asked to
define which fields in the view Access can use to create a unique index
against to allow for updating. Did you do so?
Can you edit the view directly in the link's table datasheet?
It is not unusual for a view (or query) with joins in it to become
read-only. I would think that one with 12 joins would almost always end up
this way. While joins are fine for queries and reports, they are not often
used in a form where you expect to be doing updates. Perhaps you need to
rethink that part.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com