Re: save action failed on form with multi users
From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 03/04/05
- Next message: orrin: "RE: Unbound textbox, query results"
- Previous message: Ig: "Re: Help with OpenForm"
- In reply to: Little Elvis: "save action failed on form with multi users"
- Next in thread: Elvis: "Re: save action failed on form with multi users"
- Reply: Elvis: "Re: save action failed on form with multi users"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 4 Mar 2005 22:24:55 +0800
Access 2000 and later do indeed save objects differently than 97 and
earlier. They perform a monolithic save - writing ALL the objects again when
you make a design change. Naturally that does not work properly if you are
already (and modifying) the database in a different instance.
If you have a valid reason for opening two instances of the same mdb, split
the database, make a 2nd copy of the front end connected to the same back
end, and open ONE instance of each one. This way you can do whatever you
like in each instance without messing up the other one.
Not sure if you are aware, but
DoCmd.Save
does not save the record. It saves design changes to the form.
-- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Little Elvis" <LittleElvis@discussions.microsoft.com> wrote in message news:2D90F0EB-E301-499C-BB3A-5230CC87D73C@microsoft.com... > Hello, I've an interesting problem. I'm using access 2002 SP3 > > I have a form which displays all the records in a table, with all sorts > of filtering options and sorting available for the user..There is one > value > field which the user can update..however they must update this field via > another form - which pops up when they click on the field. > In this form they can modify the value using either an increment or a > new > value. Plus there is a comment field. The comment is logged into an audit > table with the primary key field values and the user and date and time. > This all works fine..except when I start two instances of the database. > Then I cannot save the changes to the form. I get the error "save action > cancelled". > I have stripped away the audit log code. same problem. I have removed > the > onClick code in the main form...and made the change directly to the value > on > the main form. this works. I can update the values , and the change is > reflected in the other instance. > This "editing form" as I call it..is based on the same table. with some > dlookup fields on it. and the code to do the save without the audit is > very > basic... > > sub Onokclick() > docmd.save > docmd.close > end sub > > > the form properties is allow everything edits, deletions, additions etc.. > dynaset and editedrecord for locking. > > the form is opened with the acformedit keyword. > > The problem occurs with any record, even with different records in the > two instances. > > I've been able to get around it by updating the recordsetclone. But > still > wonder why it doesn't work as designed. This most likely would have worked > fine in Access 97. > > Any clues as to where I'm going wrong with this form? > > > Elvis
- Next message: orrin: "RE: Unbound textbox, query results"
- Previous message: Ig: "Re: Help with OpenForm"
- In reply to: Little Elvis: "save action failed on form with multi users"
- Next in thread: Elvis: "Re: save action failed on form with multi users"
- Reply: Elvis: "Re: save action failed on form with multi users"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
