Opening password protected Access database

Hi -

I am currently using the following VBA code to open an Access database.

Dim dbNew As DAO.Database
Set dbNew = DBEngine(0).OpenDatabase(mstrPathToDB)
Set rsSetup = dbNew.OpenRecordset("Setup")

I want to password protect the database to prevent unauthorized direct access.

What code do I need to add to unlock the database? Do I need to create a Workspace?

Thanks.

Look sample at http://smalig.tripod.com/vb/079913.html

------------------
smalig
[email protected]
smalig.tripod.com