-
Hello Vb users,
I do have a few VB5 questions about the passwords in a Accass database.
1 How can I create a Access database that is protected by a password?
Set ProjectsWS = DBEngine.Workspaces(0)
Set ProjectsDB = ProjectsWS.CreateDatabase("c:\test.mdb", dbLangGeneral)
What do I have to fill in??
2 If I made a database protected by a password, how can I change the password??
If yes, how do I do this??
Nice greetings,
Ingrid.
-
I also face this issue. Can't decode MSAccess password in VB5 program.
Ps. Need help!
Rgds,
Sam
-
Set ProjectsWS = DBEngine.Workspaces(0)
Set ProjectsDB = ProjectsWS.CreateDatabase("c:\test.mdb", dbLangGeneral)
' This will set the password for a database that does not already have a password.
'
ProjectsDB.NewPassword "", "YourPassword"
Gerald M.
[This message has been edited by Gerald (edited 12-07-1999).]