Recordset Update Issues

  • Thread starter Thread starter hntsignif
  • Start date Start date
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.
 
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.
Click to expand...


What is the RecordSource of the form? If it's a stored query, post the SQL
of the query.
 
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;
 
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;
Click to expand...


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.
 
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.
 
Back
Top