This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
To date, there is no way to protect a database with permissions as in the previous versions of Access. The only way to protect my forms, reports, codes in an Access database application is to encrypt it with a password. If I include it in the command line, the user will not need to enter the database password and will be able to launch the software, with the database remaining protected. The other method to launch the software, can be to include in code the database password, however, I do not know how to go about that. I thought of another way, to use a macro, which I can include in the command line, and this macro will run, and enter the password, enabling the user to launch the software. However, I do not know how the macro can run the password.
I will appreciate any information regarding this issue.
Thank you.
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
The only way to protect my forms, reports, codes in an Access database application is to encrypt it with a password.
Not true! Compile your application as an accde and all those will be protected.
Answer accepted by question author
I read the article in the following link
http://www.databasedev.co.uk/convert\_to\_accde\_format.html
Before converting a database to an ACCDE file, you must password protect the database and save all references to other Access databases.
Is the above statement true? If it is so, then if i protect it with a password. then how can the user open the database, if I cannot include the database password in the command line?
No the above statement is not true. This is the second time n recent months I've seen inaccuracies in articles from that site.
I create ACCDEs all the time without a password. The article is fairly accurate about what an ACCDE is but that statement is just totally false.
Answer accepted by question author
You may find the following article useful in securing your database.
I read the article in the following link
http://www.databasedev.co.uk/convert\_to\_accde\_format.html
Before converting a database to an ACCDE file, you must password protect the database and save all references to other Access databases.
Is the above statement true? If it is so, then if i protect it with a password. then how can the user open the database, if I cannot include the database password in the command line?
Thanks A milion