Forms on a Network

[data808]

I haven't tried it yet but I was just wondering if I were to put an access file in the network drive for the staff to open and enter data into forms, will it work if more than one person is trying to enter data into the forms?

[pbaldy]

A multiuser app should be split:

http://www.granite.ab.ca/access/splitapp/index.htm

[Missinglinq]

Tried Paul's link, just out of curiosity, and the link appears bad (couldn't connect x 4) so here's another tutorial:

http://www.hitechcoach.com/index.php...atid=24:design

And I'd say 'has to be split,' rather than 'should be split!'

Having multiple users sharing a single, non-split database, sitting on a network drive is the sure way to repeated episodes of corruption, as well as speed and timing problems! Multiple users simply have to work off of a split database, with each user having their own copy of the Front End, which contains everything except the data/tables, on their respective hard drives, and a Back End with only the Tables on a shared drive.

Being in forced retirement, I spend 6-8 hours a day here and on other Access forums/newsgroups, and over the past six years have seen dozens and dozens of reports of non-split apps causing these kind of problems! The really insidious thing is that a non-split app can work for extended periods of time before the troubles begin! But once it does, they become chronic, which is to say they occur over and over and over again!

Linq ;0)>