urgent help: CurrentProject.Connection

[Eyal Semo]

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

 

[TomU]

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

 

[Eyal Semo]

Tnx Tom
Can you tell me what is the name of ADO reference ?
Eyal

 

[TomU]

"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