I have a multi-user secured database running across a network. It has three
main tables which are connected by IDs and the main form has these as a form
with a subform and a subform within that. A few of my fields are mandatory
and there are a couple of combo box lookups. There are also a bunch of lookup
tables and querys.

My users two or three times a day seem to manage to corrupt the database and
i have to kick them all out, repair and let them back in. I cannot see what
is causing the db to corrupt each time and they are not reporting seeing any
error messages etc. I guess this is a really vague question but from what i
have described can anyone give me any pointers.

Secondly, i know i should split the db into FE and BE and i am currently
working on doing this. Does anyone know if doing this might help to reduce
the problem?

On a different but similar note, i was contemplating setting up a similar db
for our remote users, i.e. laptop, dial up users but decided against it as
i'm almost 100% sure that their bad habits of disconnecting themselves but
just yanking out the cable would cause identical and more frequent problems.
Would a FE/BE split help to stop this also?

Thanks
Emma