Click here to Skip to main content
16,021,765 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
hello all
i build a program which replace two record in access db
frist database has password.
how do i remove access database password in c#???
Posted

1 solution

Provided you know the existing password, it's simple:

Open a connection to the database.
Execute an ALTER statement setting it's password to NULL:
SQL
ALTER DATABASE PASSWORD [Your Password] NULL;

Close the connection
 
Share this answer
 
Comments
kavaan 20-Jan-15 5:55am    
i dont know last password...
OriginalGriff 20-Jan-15 6:14am    
Then you can't do anything.
That's what passwords are there *for* - to prevent people who aren't authorised (and anyone who doesn't know the password is unauthorised by definition) from accessing the information in the database.

Ask the person who created the DB: if you have a legitimate reason they may tell you what it is.

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