I have this code which i am using to create a access2000 database. It works well except i
now need to create it and set the password up and then i need to create a table in the database.
So i have the first part working to create the db file. This is the code i am using to create it
Dim catTmp As New ADOX.Catalog
Dim tmpUser As New ADOX.User
' Delete the database if it exists
On Error Resume Next
On Error GoTo PROC_ERR
' The Create method of the ADOX.Catalog
' creates a new database.
catTmp.Create "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strPath
Then i tried this line and it did not work
Call tmpUser.ChangePassword("", "password")
I think it has to do with opening the db thru vb in exclusive mode