I'm not expert but I've learned from hands on. I'll give this a shot; Here
goes...
You can split a Microsoft Access database into two files: one that contains
the tables and one that contains the queries, forms, reports, macros,
modules, and shortcuts to data access pages.
This way, users who need to access the data can customize their own forms,
reports, pages, and other objects while maintaining a single source of data
on the network.
On the Tools menu, point to Database Utilities, and then click Database
Splitter.
Follow the instructions in the Database Splitter Wizard dialog boxes.
THEN
Create a Replica of your db.
When you replicate a database, all the tables, queries, forms, reports,
macros, and modules are replicated by default, as well as the data. Give the
replicated db file to your intended users and you keep the original or master
file.
On the Tools menu, point to Replication, and then click Create Replica.
Click Yes when you are asked whether you want to close the database.
Click either Yes or No (Yes is recommended) when you are asked whether you
want to make a backup of the database (this dialog box is displayed only if
the database must first be converted to a Design Master (Design Master: The
only member of the replica set in which you can make changes to the database
structure that can be propagated to other replicas.) before the first replica
is created).
In the Location of New Replica dialog box, do the following:
Select the location where you want to place the new replica.
Click the Priority button, type the priority for the replica, and click OK.
Check the Prevent deletes check box if you do not want users to delete
records in the replica.
Select the replica visibility (visibility: A property of a replica that
indicates which members of the replica set it can synchronize with and which
conflict resolution rules apply. Replicas fall into three visibility types:
global, local, and anonymous.) from the Save as type box.
I think this might help... if it does, buy a Mac
