Click here to Skip to main content
15,892,059 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
How do I assign a username and password to an MS Access database?
Posted
Updated 8-Mar-13 5:41am
v2
Comments
Richard C Bishop 6-Mar-13 12:12pm    
That does not make any sense, try again.
Sandeep Mewara 6-Mar-13 12:29pm    
This is not a well framed question! We cannot work out what you are trying to do/ask from the post. Please elaborate and be specific.
Use the "Improve question" link to edit your question and provide better information.
ZurdoDev 6-Mar-13 14:43pm    
By clicking on the menus in Access. Can you be more clear on what you are trying to do?
[no name] 8-Mar-13 12:02pm    
Did you try anything? http://databases.about.com/od/tutorials/ht/Password-Protecting-An-Access-2010-Database.htm

1 solution

If i'm not wrong, Access databases (database password) are protected with SHA-1[^] algorithm.

Quote:
Database passwords were introduced back in the times of MS Access 95 as a new, easy to use security feature. Setting up a single password that controls who can open a database is both faster and easier compared to setting up a complicated user-level security. If there's a database password set, all users must enter that password to open the database.

The database password is encrypted and stored in the header of a database file. In Access versions 95 and 97 encryption was insecure and a single byte change in the header was enough to remove the password. ***

If a database header gets corrupted (usually happens when a databases is opened and saved using a text editor, MS Word is a popular choice) Access might erroneously report the database password protected instead of damaged.

src: http://www.vb123.com/toolshed/03_map/accesspasswords.htm[^]

*** - To remove password from Ms Access '97 database, replace 20B (67 - 86) in secured database with the 20B from unsecured database.
To remove password from Ms Access 2K, replace 40B, but these 40B are additionally secured with key based on file creation date.

That's all what i know ;)

[EDIT]
Create, change, or remove passwords (MDB)[^]
How to set Database Password in MS Access 2007?[^]
how to create secure access database?[^]
[/EDIT]
 
Share this answer
 
v2
Comments
Gbenbam 8-Mar-13 11:43am    
Please see the improvement to my question ?
Maciej Los 8-Mar-13 11:51am    
Do you want to that in C++ code or manually in MS Access database?
Gbenbam 8-Mar-13 12:18pm    
I will like to learn both approaches.
Maciej Los 8-Mar-13 12:27pm    
See my updated solution. I don't know how to do it programmatically.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900