By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,930 Members | 633 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,930 IT Pros & Developers. It's quick & easy.

Main/subform. Subform works but main form doesn't.

P: n/a
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!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.