Password to Access Database

[Prasad_Joshi]

Dear All,

I want to protect the Access database with password. How to protect & unprotect it through VB during adding the data by SQL.

Thanks in advance.

Prasad

[XLGibbs]

The password can be stored in your connection string...

In this case, you would actually modify and execute the queries entirely in SQL as opposed to executing saved queries and such.

If the database is password protected, I am also assuming that those using it would not have exclusive use at the time...so you can build a connection to the database in the SQL which includes the UID and PWD.

It would be standard OLE DB connection string...where you can create a connection and affect changes via SQL where the UID and PWD are stored in the code.