UnSet Access database Password

[rann]

Hi,
I need to Unset Access Database password using
VB DAO or ADO.
How do i unset access password.

I know you can change the password using

Set datInfo = OpenDatabase("mydatabase&quot
datInfo.newpassword("pwdold","pwdnew&quot

Any help or links would be appreciated,

Thanks in Advance,

Rann.

 

[johnwm]

Just send an empty string as pwdnew Let me know if this helps
________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'There are 10 kinds of people in the world: those who understand binary, and those who don't.'

 

[rann]

Hi,

1)How to access this password protected file thru VB code.
(Connection String).

You can use the below connection string to access a MSAccess
database.


gstrOLEPlanManager = "Provider=" & _
"Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strYourDatabasePath & ";" & _
"Jet OLEDBatabase Password=" & strYourPassword & ";"

2)Is it possible to set pwd for a sql or oracle db and what will be the Connection string

The connection string would be similiar but the provider type might change i dont know the exact connection syntax for Oracle. You can even use a DSN name to connect to oracle or sql.

Check out this link for oracle connection strings.

http://www.able-consulting.com/ADO_Conn.htm#ODBCDSN-LessConnections

I hope this helps,

Rann.