D
Debbie
Hello everyone,
I am trying to get a connection string to work and I have tried a variety
of things but to no avail. I have used the same connection string in an
A2003 and it works fine. The code is below:
Dim OConn As ADODB.Connection
Dim strConn As String
On Error Resume Next
Set OConn = New ADODB.Connection
OConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Documents and Settings\Owner\My
Documents\DTS\WP&L\JobTrackingBESec.mdb;" & _
"Jet OLEDB:System Database=C:\Documents and Settings\Owner\My
Documents\DTS\WP&L\WPLsystem.mdw, User Id=Patrick;Password=4554"
Set OpenConn = OConn
I receive a runtime error 3709 "This connections cannot be used to perform
this operation. It is either closed or invalid in this context."
The path statements have been triple checked, the database and system.mdw
files are correct. Does anyone know what I'm doing wrong? Are there
differences in syntax or otherwise in Access 2000? Thanks so much.
Debbie
I am trying to get a connection string to work and I have tried a variety
of things but to no avail. I have used the same connection string in an
A2003 and it works fine. The code is below:
Dim OConn As ADODB.Connection
Dim strConn As String
On Error Resume Next
Set OConn = New ADODB.Connection
OConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\Documents and Settings\Owner\My
Documents\DTS\WP&L\JobTrackingBESec.mdb;" & _
"Jet OLEDB:System Database=C:\Documents and Settings\Owner\My
Documents\DTS\WP&L\WPLsystem.mdw, User Id=Patrick;Password=4554"
Set OpenConn = OConn
I receive a runtime error 3709 "This connections cannot be used to perform
this operation. It is either closed or invalid in this context."
The path statements have been triple checked, the database and system.mdw
files are correct. Does anyone know what I'm doing wrong? Are there
differences in syntax or otherwise in Access 2000? Thanks so much.
Debbie