Recordset Update Issues


H

hntsignif

I have a button that filters a form filled with dates from two tables.

It filters the Season to Seasons and the DevCode to DevCodeA and pulls the
marketingname from the current form for display.

The dates pulled from the first table are set and do not change (except from
the table by a manager) the dates from the second table need to be updateable
as they are "actual" dates.

Name Set Date Entered Date
Milestone Mgr Set Actual Date

Right now nothing is updateable. I am getting a recordset not updateable
error.
I check both date tables and they both have primary key fields (autonumber)
and all of the other fields are not indexed.

Is it something to do with the filtering?

I am at my wits end. Please help me figure this out.
 
Ad

Advertisements

D

Dirk Goldgar

hntsignif said:
I have a button that filters a form filled with dates from two tables.

It filters the Season to Seasons and the DevCode to DevCodeA and pulls the
marketingname from the current form for display.

The dates pulled from the first table are set and do not change (except
from
the table by a manager) the dates from the second table need to be
updateable
as they are "actual" dates.

Name Set Date Entered Date
Milestone Mgr Set Actual Date

Right now nothing is updateable. I am getting a recordset not updateable
error.
I check both date tables and they both have primary key fields
(autonumber)
and all of the other fields are not indexed.

Is it something to do with the filtering?

I am at my wits end. Please help me figure this out.


What is the RecordSource of the form? If it's a stored query, post the SQL
of the query.
 
H

hntsignif

SELECT MilestoneDates.Seasons, MilestoneDates.ABrief, MilestoneDates.ADesRvw,
MilestoneDates.ADesToDev, MilestoneDates.ATPO, MilestoneDates.LPC,
MilestoneDates.LineInFlex, MilestoneDates.BBrief, MilestoneDates.NameKO,
MilestoneDates.BDesToDev, MilestoneDates.DesDebut, MilestoneDates.NameApprv,
MilestoneDates.HGCBrief, MilestoneDates.AllDesSAMM, MilestoneDates.MarcomKO,
MilestoneDates.GEOTDesRvw, MilestoneDates.AllTPOSAMM,
MilestoneDates.PkgDirRvw, MilestoneDates.ColorInFLEX,
MilestoneDates.SGCirCPADev, MilestoneDates.CopyLegalSaf,
MilestoneDates.CopyTechTIs, MilestoneDates.PIMSAMM,
MilestoneDates.ProtoTeardwn, MilestoneDates.PostSAMMtls,
MilestoneDates.MarginRvw, MilestoneDates.PkgCopyKO,
MilestoneDates.MLPContent, MilestoneDates.MLPInFLEX,
MilestoneDates.SSFlagsFinal, MilestoneDates.PIMMLP,
MilestoneDates.SGClrCodes, MilestoneDates.SGClrCodesFty,
MilestoneDates.SSConfirm, MilestoneDates.PhotoSampl,
MilestoneDates.SGPkgBrief, MilestoneDates.SGImageChk,
MilestoneDates.GEOTCatFBs, MilestoneDates.PIMCatalog,
MilestoneDates.PostSIMTools, MilestoneDates.CopyFinalPkg,
MilestoneDates.HGFinalMatrl, MilestoneDates.PricingConf,
MilestoneDates.BMLImagePost, MilestoneDates.SSShips, MilestoneDates.PIMGTM,
MilestoneDates.AllPkgOut, MilestoneDates.SockFinalMatrl,
MilestoneDates.ProdConfirm, MilestoneDates.PkgConfirm,
MilestoneDates.BuyReady, DateActuals.ABrief, DateActuals.ADesRvw,
DateActuals.ADesToDev, DateActuals.ATPO, DateActuals.LPC,
DateActuals.LineInFlex, DateActuals.BBrief, DateActuals.NameKO,
DateActuals.BDesToDev, DateActuals.DesDebut, DateActuals.NameApprv,
DateActuals.HGCBrief, DateActuals.AllDesSAMM, DateActuals.MarcomKO,
DateActuals.GEOTDesRvw, DateActuals.AllTPOSAMM, DateActuals.PkgDirRvw,
DateActuals.ColorInFLEX, DateActuals.SGCirCPADev, DateActuals.CopyLegalSaf,
DateActuals.CopyTechTIs, DateActuals.PIMSAMM, DateActuals.ProtoTeardwn,
DateActuals.PostSAMMtls, DateActuals.MarginRvw, DateActuals.PkgCopyKO,
DateActuals.MLPContent, DateActuals.MLPInFLEX, DateActuals.SSFlagsFinal,
DateActuals.PIMMLP, DateActuals.SGClrCodes, DateActuals.SGClrCodesFty,
DateActuals.SSConfirm, DateActuals.PhotoSampl, DateActuals.SGPkgBrief,
DateActuals.SGImageChk, DateActuals.GEOTCatFBs, DateActuals.PIMCatalog,
DateActuals.PostSIMTools, DateActuals.CopyFinalPkg, DateActuals.HGFinalMatrl,
DateActuals.PricingConf, DateActuals.BMLImagePost, DateActuals.SSShips,
DateActuals.PIMGTM, DateActuals.AllPkgOut, DateActuals.SockFinalMatrl,
DateActuals.ProdConfirm, DateActuals.PkgConfirm, DateActuals.BuyReady,
DateActuals.DevCodeA, DateActuals.DesRefine, MilestoneDates.DesRefine AS
DesRefine_MilestoneDates, MarcomPackaging.MARKETINGNAME,
MilestoneDates.Seasons FROM (MarcomPackaging INNER JOIN MilestoneDates ON
MarcomPackaging.Season=MilestoneDates.Seasons) INNER JOIN DateActuals ON
MarcomPackaging.TrackingNo=DateActuals.DevCodeA;
 
D

Dirk Goldgar

hntsignif said:
SELECT MilestoneDates.Seasons, MilestoneDates.ABrief,
MilestoneDates.ADesRvw,
MilestoneDates.ADesToDev, MilestoneDates.ATPO, MilestoneDates.LPC,
MilestoneDates.LineInFlex, MilestoneDates.BBrief, MilestoneDates.NameKO,
MilestoneDates.BDesToDev, MilestoneDates.DesDebut,
MilestoneDates.NameApprv,
MilestoneDates.HGCBrief, MilestoneDates.AllDesSAMM,
MilestoneDates.MarcomKO,
MilestoneDates.GEOTDesRvw, MilestoneDates.AllTPOSAMM,
MilestoneDates.PkgDirRvw, MilestoneDates.ColorInFLEX,
MilestoneDates.SGCirCPADev, MilestoneDates.CopyLegalSaf,
MilestoneDates.CopyTechTIs, MilestoneDates.PIMSAMM,
MilestoneDates.ProtoTeardwn, MilestoneDates.PostSAMMtls,
MilestoneDates.MarginRvw, MilestoneDates.PkgCopyKO,
MilestoneDates.MLPContent, MilestoneDates.MLPInFLEX,
MilestoneDates.SSFlagsFinal, MilestoneDates.PIMMLP,
MilestoneDates.SGClrCodes, MilestoneDates.SGClrCodesFty,
MilestoneDates.SSConfirm, MilestoneDates.PhotoSampl,
MilestoneDates.SGPkgBrief, MilestoneDates.SGImageChk,
MilestoneDates.GEOTCatFBs, MilestoneDates.PIMCatalog,
MilestoneDates.PostSIMTools, MilestoneDates.CopyFinalPkg,
MilestoneDates.HGFinalMatrl, MilestoneDates.PricingConf,
MilestoneDates.BMLImagePost, MilestoneDates.SSShips,
MilestoneDates.PIMGTM,
MilestoneDates.AllPkgOut, MilestoneDates.SockFinalMatrl,
MilestoneDates.ProdConfirm, MilestoneDates.PkgConfirm,
MilestoneDates.BuyReady, DateActuals.ABrief, DateActuals.ADesRvw,
DateActuals.ADesToDev, DateActuals.ATPO, DateActuals.LPC,
DateActuals.LineInFlex, DateActuals.BBrief, DateActuals.NameKO,
DateActuals.BDesToDev, DateActuals.DesDebut, DateActuals.NameApprv,
DateActuals.HGCBrief, DateActuals.AllDesSAMM, DateActuals.MarcomKO,
DateActuals.GEOTDesRvw, DateActuals.AllTPOSAMM, DateActuals.PkgDirRvw,
DateActuals.ColorInFLEX, DateActuals.SGCirCPADev,
DateActuals.CopyLegalSaf,
DateActuals.CopyTechTIs, DateActuals.PIMSAMM, DateActuals.ProtoTeardwn,
DateActuals.PostSAMMtls, DateActuals.MarginRvw, DateActuals.PkgCopyKO,
DateActuals.MLPContent, DateActuals.MLPInFLEX, DateActuals.SSFlagsFinal,
DateActuals.PIMMLP, DateActuals.SGClrCodes, DateActuals.SGClrCodesFty,
DateActuals.SSConfirm, DateActuals.PhotoSampl, DateActuals.SGPkgBrief,
DateActuals.SGImageChk, DateActuals.GEOTCatFBs, DateActuals.PIMCatalog,
DateActuals.PostSIMTools, DateActuals.CopyFinalPkg,
DateActuals.HGFinalMatrl,
DateActuals.PricingConf, DateActuals.BMLImagePost, DateActuals.SSShips,
DateActuals.PIMGTM, DateActuals.AllPkgOut, DateActuals.SockFinalMatrl,
DateActuals.ProdConfirm, DateActuals.PkgConfirm, DateActuals.BuyReady,
DateActuals.DevCodeA, DateActuals.DesRefine, MilestoneDates.DesRefine AS
DesRefine_MilestoneDates, MarcomPackaging.MARKETINGNAME,
MilestoneDates.Seasons FROM (MarcomPackaging INNER JOIN MilestoneDates ON
MarcomPackaging.Season=MilestoneDates.Seasons) INNER JOIN DateActuals ON
MarcomPackaging.TrackingNo=DateActuals.DevCodeA;


I can't be sure, but this may be a case of a query that is not updatable
because it includes three tables in a many-to-one-to-many relationship. Try
changing the form's Recordset Type property (on the Data tab of the form's
property sheet) to "Dynaset (Inconsistent Updates)". If that doesn't make
at least some of the fields updatable, modify the query so that it includes
the linking fields from all tables, and (if not already done) index those
fields.
 
Ad

Advertisements

H

hntsignif

That did it :) I changed the Type to Dynaset (Inconsistent Updates) and it
is now working!

Thanks a bunch. This one was driving me buggy. I can usually figure them
out but this forum has been fantastic for those times I just can't find the
anwsers on my own.
 

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

Top