Crazy Error only on one computer .Connection Error in DLL

[DougP]

I have one computer that gives an error only when trying to run any .MDB file
It runs fine when compiled into a .mde.
this is the line:
Set Conn2 = CurrentProject.Connection
"Error in DLL" is all the message says.
If I rem out the line it goes until it trys to open the connection which it can't since this statement is REMed out. Is there s different DLL used in and MDB than and MDE? I looked to see if any references are missing and they are not. I did a repair on Access says successful. Still won't work.


DougP, MCP, A+
I Built my own R2D2
I love this site and all you folks that helped me over the years!

 

[PHV]

What is the value of Err.LastDllError when the error raises ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DougP]

Ok now its working, Go figure
I went there to get what you said and it works just fine now. The user said they didn't do anything different.


DougP, MCP, A+
I Built my own R2D2
I love this site and all you folks that helped me over the years!