Thursday 1 September 2011

Password in Access 2007

I was working with access 2003 and have now installed Access 2007. In my files, I have passwords. How do I remove these passwords in Access 2007 and also when opened and / or how do you create passwords as soon as they open? Among other things, how do you view the tables, queries, forms, etc. ... or it is like that they are already created? Thank in advance
Hello , Can You see the Encryption option? It might be there. and also You set and remove a database password in Microsoft Office Access 2007 by using the Set Database Password and Unset Database Password dialog boxes. These dialog boxes appear when you click the Encrypt with Password command and the Remove Database Password And Encryption command , respectively, in the Database Tools group on the Database Tools tab. Are you sure that they used Access' password protection and not some homebrewed password? Try opening the database while holding down the F11 key. If you aren't prompted for a password, it was homebrewed. If the F11 key is disabled, check out the code behind the opening form
For more useful tips & hints, please browse for more information at our website:-
quick pre-patch
firmware update
When you remove a password from a database, you can restore it at any time (or replace it with another password) by repeating the steps in Encrypt a database by using a password,

Remove a password
Open the database in Exclusive mode.
On the Database Tools tab, in the Database Tools group, click Decrypt Database.
The Unset Database Password dialog box appears.
Type your password in the Password box, and then click OK.

__________________

No comments:

Post a Comment