Complie Error, Error in loadind Dll

[naym]

Hi Guys,

I have a issue which I have been trying to work on all day.

I have windows 7 and office 2003 installed.
I have access application which was running fine recently but for some reason everytime I run it now it gives an error on the adodb connection string saying compile error.
Its doing this on every adodb connection I have in my database.

I have tried registering the dao an ado dlls but still the problem persists.

Guys Any help would be highly appreciated.

Thanks

 

[DavidAtWork]

Can you post a sample of your connection string. Also has it run successfully under Win 7 or have you recently installed Win 7
David

 

[mdlueck]

Perhaps the ADO library is no longer a reference in you VBA editor? That would cause the error you describe. In the VBA editor Tools \ References \ Microsoft ActiveX Data Objects 2.8 Library should be checked. (Or what ever version of MDAC is installed on your computer.) 2.8 works on my XP and Win7 machines.

 

[naym]

Hi David, Michael.

Thank you for your reply, sorry for not getting back in touch earlier.

David the connection string is simple and its been used for years on xp and on windows 7 before and goes something like..

strTemp = "Select * from postcode where postcode='" & pc & "'"
rs.Open strTemp, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
.
and Michael I have checked them and they are referenced but error still comes up.
when i run it, it says dll compile error 48.

I Have been leaving my pc in sleep mode quite often and also recently i installed and removed a database programme so I dont know maybe that may have caused the issue or a windows up.

If I take the database and load it onto XP it works fine just on this particular windows 7 machine.

Im thinking maybe a adodb dll or the mdac may have a problem but where is the mdac file in windows 7? or should i run the windows 7 repair or something??
any ideas Guys??