please help!! non-updateable forms in ADP


J

Jon Eckstein

hello,
any help anyone can give me would be greatly appreciated. i feel like
i've tried EVERYTHING..here's the situation:
access2k(sp3) -> sqlserver2000(sp?); a project management database:
affected tables:
tblPhs - phases (one or many activites)
tblAct - activities (one or many actlbr records)
tblActLbr - projected labor for each activity

the system is very big and i'm using a bunch of views to show roll-up
numbers dynamically. so i have a phase form with an activity
sub-form..
this activity sub-form is bound to a view for activities which
contains roll-up numbers for each of its associated actlbr records, in
order to show those rollups on the form. ***i cannot update the
activity sub-form** why?
i'm giving access the primary key for tblAct, there should be no
reason why I can't update tblAct through the view.
i've checked for pks, set the unique table, played w/ stored
procedures (resync command), played with WITH VIEW_METADATA option and
INSTEAD OF Triggers..NOTHING WORKS..please help..
thanks,
jon
 
Ad

Advertisements

B

Bryan

Is the subform based on a table, view or stored
procedure. If stored procedure it can't be updated. Are
you sure you have a primary key on all tables involved.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot Update View in ADP Form! help! 3
ADP and Forms 1
ADP forms 7
Forms with ADP 9
ADP Help 15
ADP help 0
ADP: update data 1
adp/sql2k data updatability with a bound form 1

Top