Multi-users entering data in a single form

[Meredith Mcgowan via AccessMonster.com]

I'm having trouble with one of my forms. My database is set up on a server
so that multi- users can access it at once. However, when one user opens a
form to enter data and before the user closes the form, a second user opens
the same form to enter different data, the form only collects the data from
the first user. Ex. The first user opens and the record is on 40. The
second user opens the same form and since the first users data is not
complete of saved, the second user is on record 40 too. Any ideas? I'm
tired of losing data.

 

[Nikos Yannacopoulos]

Meredith,

Split, split, split! You could be in for much worse (like losing the
whole thing!). Use Access's built-in splitter (Tools > Database
Utilities > Database Splitter) to split your database in a front end /
back end, leave the BE on the server and distribute a personal copy of
the FE to each user. Browse through the access.multiuser NG, you will
learn a lot on the subject.

HTH,
Nikos

 

[Meredith Mcgowan via AccessMonster.com]

Thanks for the information. I now have it set up with a split database and
multiple users are able to save data. One new problem, every once in a
while we get an "invalid argument" error. I close the database, reopen,
recreate what I previously did, and this time I do not get the error. I
can not find a commonality that is causing the error to occur. I did not
get this error before the split. Any ideas?

 

[Nikos Yannacopoulos]

Meredith,

Impossible to tell without info. I suppose it doesn't just happen out of
the blue, it's gotta be when you do something like clicking a command
button, opening a form, moving to another record or saving a record in a
form, or what? Any code behind a triggered event?

Also, a look at:
http://www.granite.ab.ca/access/performancefaq.htm
is well worth your time. Start with the persistent recordset; even
though I have no clue right now where your problem comes from, there's a
chance this might solve it, but even if it doesn't, the performance
improvement alone more than justifies your trouble.

Nikos