Web programming Tips
How to create MS Access Application
By Sergey Skudaev
(Password Keeper)
Person who use computer for many tasks often has to remember many passwords. It is possible to save all your passwords in one file on desktop, but then any intruder from internet may read the file and get access to your accounts. It is better to keep all your passwords in password protected database. I will show you how to create a password protected MS Access application to store your login, passwords, and accounts. First we need to create a database and a table. For details you may read my tutorial Database Design and Implementation.
Open MS Access and click File, New. Then select empty database. File New Database window displays. Enter file name password_keeper.mdb and click Create button. A new database is created.
Select Tables in Object panel and click "Create table in design view" Table1 window displays in design view. Enter fields names and data types.
| accessid | Autonumber |
| target | text 100 characters |
| Login | text leave default 50 character |
| Password | text leave default 50 character |
| Note | memo |
See figure 1. Hover mouse over a thumbnail to see large image.
Figure 1.
Click accessed field by right mouse button and select Primary key. Save table with name passwords.
Select Forms on Object panel and click Create by using wizard. See figure 2.
Figure 2.
When Form Wizard window is displayed, select table passwords and move each field, except accessid, from Available Fields panel to Selected fields panel by selecting a field and clicking > button. See figure 3 and 4
Figure 3.
Figure 4.
When all fields are moved click Next button. Form Wizard Displays with Layout choices. Select Justified. See figure 5.
Figure 5.
Click Next button. Form Wizard with style choices displays. Select any choice you loke. See Figure 6
Figure 6.
Click Next button.
Figure 7.
Enter Form name "Passwords" and select Modify the form's design. On Form in design view you can move and resize fields how you like.
Figure 8.
Click Tool box icon on main tool bar. See Figure 9.
Figure 9.
Tool box displays. See figure 10
Figure 10.
On tool box click button control and draw it on the form. Command Button Wizard window displays. See Figure 11
Figure 11.
Figure 12.
Select Find Record and click Next button. See Figure 12, 13.
Figure 13.
Select Text radio button. Click Next button. See Figure 14.
Figure 14.
Enter button name: Find Record. Click Finish button.
Select View Form View. See Figure 15
Figure 15.
The form displays in form view. See Figure 16
Figure 16.
The Password Keeper Application is ready. Now you have to set password for its database. Close your application. Select File open. Open dialog displays
Figure 17.
Select a small arrow next to open button. Drop down menu displays. See Figure 17. Select Open Exclusively. To be able to set password, you have to open database exclusively. It means, nobody else can open it or connect to it at the same time.
Select Tools, Security, Set Database Password from main tool bar. See figure 18.
Figure 18.
Enter password two times. Click OK. See Figure 19
Figure 19.
Now your database password protected. Click Password form and Login window displays See figure 20.
Figure 20.
Enter password and form displays. In target field enter your account url or application name. In login field enter login. In password field enter password. In Note field you can enter whatever you like, for example, secret question and answer that you entered while created your account. To save record click arrow button at the bottom of the form. Empty fields are displayed for the next record. The first record is saved. You are done.
Figure 21.
Download Password Keeper MS Access application It was created with MS Access 2003 and may not work with previous versions of MS Access.
If you have any question or comments please post them in forum
Password Keeper VB Application
* * *
If you do not like to read from screen you can download all contents of this web site as PDF file, print it out and read it seating in a comfortable chair.
To see the link, you have to be registered visitor. If I did not registered. Please register on my site .
Did you find information useful? Send to your friend a link to this page
Please rate the tutorial
| Comments |
|---|
