Can a secured 2010 db be opened via 2010 runtime?

[bobduncan43]

Can a secured 2010 db be opened via 2010 runtime? The users open the database via a desktop shortcut and they are prompted for a password.



I am NOT a programmer; just an amateur looking for help, so thanks in advance.

[Amicron]

What kind of security do you have in place? If you have set a database password, then YES, they're going to be prompted for that password. If you want to keep users out of your database code and form design, the best thing to do is just ENCRYPT the database and make an ACCDE file out of it.

[tanvi]

Yes, you can protect your database with password. Here are all steps:


1. First open the database that you want to password protect in exclusive mode. You may do this by selecting Open from the file menu and navigating to the database you'd like to encrypt and then click it once. Then, instead of just clicking the Open button, click the downward arrow icon to the right of the button. Choose "Open Exclusive" to open the database in exclusive mode.
2. When the database opens, go to the File tab and click the Info button.
3. Click the Encrypt with Password button.
4. Choose a strong password for your database and enter it in both the Password and Verify boxes in the Set Database Password dialog box, as shown in the image above. Once you've done this, click OK.
5. That's all there is to it. After clicking OK, your database will be encrypted. (This may take a while depending upon the size of your database). The next time you open your database, you'll be prompted to enter the password before accessing it.

Ref: http://databases.about.com/od/tutori...0-Database.htm