I suggest you start by reading http://support.microsoft.com/default.aspx?scid=kb;[LN];207793 It may have
what you want there. Also check out the features of creating an mde file
rather than a mdb file. It sounds like you would be well served by leaning
about the security features of Access.
Access security is a great feature, but it is, by nature a complex product
with a very steep learning curve. Properly used it offers very safe
versatile protection and control. However a simple mistake can lock
everyone including God out.
Practice on some copies to make sure you know what you are doing.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.