IIRC (have done some big Access development, but not in past couple years), it should notice that the record has changed and prompt. It should prohibit you from editing at all if the table design is being modified by somebody (and prohibit you from opening the form if somebody has that open in design mode), but if just editing data you should be able to edit simultaneously and it will tell you if current record has been modified.
You really should split out the tables into a separate mdb, and link them from the forms mdb or mde; that way you can have multiple copies of that forms mdb/mde, which you can restore without any data loss. Access needs a compact/repair once a week or so, especially with multiple people using simultaneously. (and you still may wind up with some form corruption) - David On Fri, Jan 16, 2009 at 9:54 AM, Scott Raley -ITC <[email protected]> wrote: > Well that was the first thing I thought of doing but I can't find anything > that says access will store the data if two people go in at the same time to > enter in records using the mde. > > -----Original Message----- > From: Michael Grant [mailto:[email protected]] > Sent: Friday, January 16, 2009 9:08 AM > To: cf-community > Subject: RE: MS Access > > I think you may need to turn it into a MDE file. I'm looking at an old > (circa 2001) access program they used to use at my work which allowed > network access and multiple users and in the program folder there's the a > ..mdb file and a .mde file. We have to run the mde to use the program. > > Hopefully this is helpful and not just mis-directing you. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:285151 Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
