open a password protected database with vba code using ecxel as fr

[Manos]

I have created a program using excel as front and linking to a access
database. To secure data integrity, I wish to password protect the database
and then use vba code to open and get or append data.

 

[Alex Dybenko]

Hi,
how do you open your database now? using DAO?
then you can open it like this:

DBEngine.OpenDatabase(strFileName, False, True, ";pwd=" & strPassword)

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com