Prompt user for userID and password after sent via Email

[chillay]

Hello

I secured my Access database and setup users and groups. When I open the database it prompts me for a userID and password which is great but I want to send this database to someone else via e-mail and I want the database to prompt the user for a userID and password.

I noticed that when I delete the database and copy it somewhere else on my computer it does not prompt me for a password.

MY QUESTION:

How can I ensure that the database prompts the user for a userID and password when they receive the database via e-mail.

Thanks a bunch!

Chillay

 

[easyit]

To do this, the other user needs access tot the .mdw file in which security information is stored. This will only work if the DB is properly secured. If not, the mailed DB will be openend by anyone using the default .mdw, in which they are Administrators.

Are you using a shared network? In that case the mdw file can be shared as well. if not, and the mailreceipent is a single user of the database then you could probably also use the databas password option.

Maarten