Running App that opens a Password-set Access DB

[Micash]

I have created an application that utilizes an Access97 Database. I would now like to password protect the database. I need to know if there is a relatively easy way of coding in the password so that the application can access the data. Thanks very much! - Micash

 

[JeremyM]

Yes. If the database is password protected, you feed it the password on the open DB command. Look for the syntax on the help file. But the second or third filed is for password when establishing a connection.

Jeremy

 

[swilliams]

Using DAO:

Dim db As Database
Set db = Workspaces(0).OpenDatabase("C:\aa\db1.mdb", False, False,"PWD=password&quot

Using ADO (and ODBC data source):

Dim cnn As New ADODB.Connection
Dim strCon As String
strCon = "Data Source=ODBCSource;UID=user;Password=password"
cnn.Open strCon

Simon