Passwords in Access

[ingrid]

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.

[samccw]

I also face this issue. Can't decode MSAccess password in VB5 program.

Ps. Need help!

Rgds,
Sam

[Gerald]

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).]