Hi SGH,
You will need to implement Access user level security. You need to do
this with great care, because it is possible to lock yourself out of
your own database. Study the Security FAQ thoroughly before you start,
and make certain that you have a backup copy of the database.
The following links should take you to the necessary information:
Security FAQ - includes explanations and step by step instructions
http://support.microsoft.com/?id=207793
or
http://support.microsoft.com/support/access/content/secfaq.asp
Security Whitepaper (old, but explains the concepts)
http://support.microsoft.com/?id=148555
Hoy can I prevent the import of MS Access database objects
from other databases? The AllowByPass method and the
password protection are not valid for this purpose. Thanks.
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.