Groups | Search | Server Info | Login | Register

Groups > comp.databases.ms-access > #730

Re: Error 2759 saving record Access 2010

Show all headers | View raw

Thanks Tony. I tried your suggestion but still the same message.


-- 
Bob Darlington
Brisbane
"Tony Toews" <ttoews@telusplanet.net> wrote in message 
news:70u9p6h146h652306in803nfdfgfqq2p1g@4ax.com...
> On Thu, 31 Mar 2011 16:40:19 +1000, "Bob Darlington"
> <bob@notheredpcman.com.au> 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/ 

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Error 2759 saving record Access 2010 "Bob Darlington" <bob@notheredpcman.com.au> - 2011-03-31 16:40 +1000
  Re: Error 2759 saving record Access 2010 Tony Toews <ttoews@telusplanet.net> - 2011-03-31 15:55 -0600
    Re: Error 2759 saving record Access 2010 "Bob Darlington" <bob@notheredpcman.com.au> - 2011-04-01 08:46 +1000
    Re: Error 2759 saving record Access 2010 "Bob Darlington" <bob@notheredpcman.com.au> - 2011-04-01 09:25 +1000
    Re: Error 2759 saving record Access 2010 "David-W-Fenton" <NoEmail@SeeSignature.invalid> - 2011-04-01 19:56 +0000
      Re: Error 2759 saving record Access 2010 Tony Toews <ttoews@telusplanet.net> - 2011-04-03 22:31 -0600
        Re: Error 2759 saving record Access 2010 "David-W-Fenton" <NoEmail@SeeSignature.invalid> - 2011-04-06 17:10 +0000

csiph-web