Well ... simple is a relative term. If your database is very, very simple
then split the db into frontend (forms, reports, etc) and backend (tables),
deploy a frontend to each user, run the Linked Table Manager to relink each
frontend to the backend, and then you're good to go. Af far as the Word
macro, you'll probably have to recode it in each users copy of Word.
This is a very simplistic view of sharing a database. There are a multitude
of problems associated with improperly sharing a Jet (Access) database, not
the least of which is corruption and loss of data. I'd encourage you to
readup on the many posts in the newsgroups regarding multiuser issues,
cruise some of the many websites devoted to Access and mutliuser issues, and
get yourself a copy of the Access Developer's handbook for XP. You'll need
it.
