Path: csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!nx02.iad01.newshosting.com!newshosting.com!novia!news1.optus.net.au!optus!newsfeeder.syd.optusnet.com.au!news.optusnet.com.au!not-for-mail Reply-To: "Bob Darlington" From: "Bob Darlington" Newsgroups: comp.databases.ms-access References: <4d9421c5$0$19225$afc38c87@news.optusnet.com.au> <70u9p6h146h652306in803nfdfgfqq2p1g@4ax.com> Subject: Re: Error 2759 saving record Access 2010 Date: Fri, 1 Apr 2011 08:46:46 +1000 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.5931 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5994 Lines: 46 Message-ID: <4d950446$0$2448$afc38c87@news.optusnet.com.au> NNTP-Posting-Host: 114.77.140.94 X-Trace: 1301611590 2448 114.77.140.94 Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-access:730 Thanks Tony. I tried your suggestion but still the same message. -- Bob Darlington Brisbane "Tony Toews" wrote in message news:70u9p6h146h652306in803nfdfgfqq2p1g@4ax.com... > On Thu, 31 Mar 2011 16:40:19 +1000, "Bob Darlington" > wrote: > >>I'm using Access 2010 to open an Access 2002 mdb front end linked to an >>Access 2002 backend. >>I have the following code in the AfterUpdate event on a control to force >>the >>record to be saved before proceeding. >> >>DoCmd.RunCommand acCmdSaveRecord >> >>When it encounters this line, I get the following error: >>'The method you tried to invoke on an object failed.' (Error 2759). >>The same thing happens if I use Me.Dirty = False >> >>But the record gets saved anyway. >>All references are in tact. >> >>If I test the same frontend mdb on another PC using Access 2002 and linked >>via the LAN to the same data file, I don't get the message. >>Any ideas out there. > > If I recall correctly A2003 and newer requre that the record be dirty > before you can execute the code to save it. So check to see if the > record is dirty before saving it. > > If me.dirty = true then _ > DoCmd.RunCommand acCmdSaveRecord > > Tony > -- > Tony Toews, Microsoft Access MVP > Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm > Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ > For a convenient utility to keep your users FEs and other files > updated see http://www.autofeupdater.com/