This article is meant to provide the best practices for sharing a database with others. Incorporated into these best practices are the concepts of maximum security, future manageability, and higher degrees of scalability. Simply put, your database will be as secure as possible, as easy to modify as possible, and as easy to migrate to a larger platform when and if you ever outgrow Access.
Sharing your database
http://www.utteraccess.com/wiki/Sharing