Your application should be split into a front-end (containing the queries,
forms, reports, macros and modules) and a back-end (containing the tables).
Only the back-end should be on the server: each user should have his/her own
copy of the front-end on their hard drive. In that way, one user's setup
won't impact another's.

See what Tony Toews has at
http://www.granite.ab.ca/access/splitapp/index.htm for more details.