urgent help: CurrentProject.Connection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello people
until this morning all my ADO connection worked, suddenly I am getting an
error while compiling my VS modules
the error applies to - CurrentProject.Connection
"error on loading dll"
what dll ? and what should I do to correct it?
Thank you all I need it badly, Eyal

for example:

Dim rel1 As Recordset
Set rel1 = New ADODB.Recordset
rel1.CursorLocation = adUseClient
rel1.Open "Select subtotal From orderline where order_number='" & tcode &
"'", CurrentProject.Connection, adOpenKeyset, adLockOptimistic

rel1.MoveFirst
While Not rel1.EOF
tcalc = tcalc + rel1!subtotal * 1
rel1.MoveNext
Wend

rel1.Close
Set rel1 = Nothing
 
Change your declaration to:
Dim rel1 As ADODB.Recordset

I suspect that the sequence of your references changes so that ADO comes
after DAO so Access interpreted your declaration as calling for a DAO
recordset.

Tom Unkefer
 
"Microsoft ActiveX Data Objects 2.x Library"

2.x may be 2.5 through 2.8 depending on what is installed on your system and
user systems.

Tom Unkefer
 
Back
Top