471,305 Members | 1,026 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,305 software developers and data experts.

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

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
1 2075
"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.

Similar topics

9 posts views Thread by William Wisnieski | last post: by
18 posts views Thread by Darryl Kerkeslager | last post: by
17 posts views Thread by Neil Ginsberg | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.