Hi,
I have been trying to open a connection with an ACCESS database but am not able to do so.
PLZZ HELP
Printable View
Hi,
I have been trying to open a connection with an ACCESS database but am not able to do so.
PLZZ HELP
we would need some more information like....
your code?
here is a typical connection to a locked access db
VB Code:
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
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