Connection String For Locked Access Database

[morphiz]

Hi,

I have been trying to open a connection with an ACCESS database but am not able to do so.

PLZZ HELP

[kleinma]

we would need some more information like....

your code?

[tina104291325]

here is a typical connection to a locked access db

DBSource = DBProvider & "Data Source=" & App.Path & "\" & DBNAME
        Set cnn = New ADODB.Connection
        cnn.ConnectionString = DBSource
        cnn.Properties("Jet OLEDB:database Password").Value = "password"
        cnn.Open

but there is a database forum for that

[morphiz]

Public Sub Conn()
Dim strCon As String
Set cn = New ADODB.connection
strCon = "Provider=Microsoft.Jet.OLEDB.3.51;uid=admin;pwd=try;Persist Security Info=false;Data Source=" & _
App.Path & "\stock.mdb"
cn.Open strCon