Remove the "persist security info" (used with SQL not Access) and add the following:
Jet OLEDB:Database Password=password

So your new connection string should read:

strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strDBPath & "security.mdb;Jet OLEDB:Database Password=typepass"

:where 'typepass' is your database password.


If this doesn't work make sure you have the latest MDAC (currently 2.6 SP1) available at http://www.microsoft.com/data/download.htm. Let me know what works for ya. Cheers.