OPEN PROTECTED DATABASE USING SQL

[pelagic]

Hi there,
SQL code used to work before. After I added the password to REPORT database this code is no longer work. The error message that I am getting is:
Run-time error (-2147467259)
Not a valid password.
I wonder why this happend even though I have provided the correct password for REPORT database.

Any hint will help
thanks,

strPathtoDB2 = App.Path & "\REPORT.mdb;"

cn2.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strPathtoDB2 & _
" Jet OLEDBatabase Password=pwd" 'connection string

cn1.Execute "SELECT * INTO tblREPORT IN " & _
" REPORT.mdb FROM tblDATA"

 

[nigelrivett]

From

http://www.able-consulting.com/ADO_Conn.htm#ODBCDriverForSQLServer

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mydb.mdb;" & _
"Jet OLEDBatabase Password=MyDbPassword", _
"myUsername", "myPassword"


======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.