Brinkster Knowledge Base

KB Home   /  Support  /  Database  /  MS Access  /   Password Protected MS Access Connection String
Password Protected MS Access Connection String Articles
If you have password protected your MS Access database, you can mimic the following connection string.

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" _
        & "Data Source=C:\sites\Single??\Username\database\YourDB.mdb;" _
        & "Jet OLEDB:Database Password=Password;"



Important Notes:

1. You will need to replace the "Data Source" parameter above with the path that corresponds to the path of your account. This can be found in "Website Settings" from within your control panel.

2. Replace the "Password" parameter above with the password that you set on your database.