Subform source object and corruption

[BarbaraC]

I have been having a big problem with corruption with one
of my applications (about 10 users). I have read lots of
articles and am trying to narrow down the cause.

My application is used for creating medical reports -
currently for 4 different test formats. So in my main
form I have included a subform called "FS-Results".
Depending upon which test the user wants to enter results
for I change the source object of the "FS-Results" subform
to be the appropriate subform containing the correct
fields for that test (e.g. Test1Subform, Test2Subform,
etc.). Is this a bad practice? I can't seem to find
anything else in my code that should be causing a problem.

 

[Ken Snell]

Are all ten users using the same database (the one with the forms, etc. in
it) at the same time? Not a good way to keep a database from corrupting if
you are.

In multiuser situations, split the database into front end databases (they
contain the forms, queries, reports, etc., and links to tables that are in
the back end database) and one back end database (that contains all the
tables and data). Each user gets his/her own copy of the front end, and each
front end is linked to the back end.

See Tony Toews' web site for more info:
http://www.granite.ab.ca/access/splitapp/index.htm