The best way is to split the application into a front-end (containing the
queries, forms, reports, macros and modules), linked to a back-end
(containing just the tables). Only the back-end goes on the server. Each
user should have his/her own copy of the front-end on their hard drive.