Change password programatically for access database

  • Thread starter Thread starter Nak
  • Start date Start date
N

Nak

Hi there,

I was wondering if it is at all possible to programatically change a
password for an access database using VB.NET? Do I use a specific SQL
command to perform such a task? Thanks in advance.

Nick.
 
Hi Nick,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that you need to change the Access database
password in VB.NET using a SQL statement. If there is any misunderstanding,
please feel free to let me know.

As far as I know, we can use ALTER DATABASE PASSWORD statement to achieve
this. We can put the statement in an OleDbCommand and execute it. For more
information, please check the following links:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/htm
l/acadvsql.asp
http://support.microsoft.com/?kbid=304915

This statement seems to apply to Access 2000 and later version. HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."
 
Back
Top