Split your database. Be sure and make a backup copy FIRST. Then go into
tools/database utilities/database splitter and split the database into 2
pieces. One will be your mdb and contain all your queries, forms, reports,
and pages. The other, called the BE will be your tables. The mdb will now
contain links to all your tables. Some people then recommend that you go
ahead and create an mde file if you are concerned about security. Read the
help file on mde if you you are concerned about it. With the mdb and BE on
your lan, go to each user and copy the mdb into their My Documents folder.
Then create a shortcut to it on their desktop. Now users will each have their
own copies of the forms, report, and be linked to the tables on the LAN.
Albert Kallal has a great article on database splitting at
www.member.shaw.ca/albertkallal