compile error in loading dll

[Guest]

I am using Access 2003.

When I load my database, when the switchboard tries to load I get an error
"Compile error in loading dll". The word connection is highlighted in the
following statement:
Set con = Application.CurrentProject.Connection

I have seen others with this problem but no solutions.

Can anyone help?

Thanks in advance.

Mark

 

[Guest]

Hi Mark,

It sounds like your MDAC installation is hosed. Try using the MDAC Component
Checker, which you can download from here:

http://support.microsoft.com/?id=307255


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I am using Access 2003.

When I load my database, when the switchboard tries to load I get an error
"Compile error in loading dll". The word connection is highlighted in the
following statement:
Set con = Application.CurrentProject.Connection

I have seen others with this problem but no solutions.

Can anyone help?

Thanks in advance.

Mark

 

[Guest]

PS.
I assume you have already checked for any MISSING references, and/or
refreshed your references list, since you stated "I have seen others with
this problem but no solutions."

Solving Problems with Library References (Allen Browne)
http://allenbrowne.com/ser-38.html

Access Reference Problems (Doug Steele)
http://www.accessmvp.com/djsteele/AccessReferenceErrors.html


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

Hi Mark,

It sounds like your MDAC installation is hosed. Try using the MDAC Component
Checker, which you can download from here:

http://support.microsoft.com/?id=307255


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I am using Access 2003.

When I load my database, when the switchboard tries to load I get an error
"Compile error in loading dll". The word connection is highlighted in the
following statement:
Set con = Application.CurrentProject.Connection

I have seen others with this problem but no solutions.

Can anyone help?

Thanks in advance.

Mark

 

[Guest]

Hi Robert,

You answered to "Mark", however, I am unable to find the message when using
the MS web portal, the Comcast News Server (using Outlook Express
newsreader), or via a Google search. It is helpful to include the text of the
message that you are replying to, so that in case others do not see the
original message, at least they can read it if you include it (as I have
included your post, below).

I recommend re-registering the following three files. Note that the path to
each file may be different on your PC. To do this, click on Start > Run. Then
copy each of the statements shown below, one-at-a-time, and click on Enter:

Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao350.dll
Regsvr32.exe C:\progra~1\common~1\micros~1\dao\dao360.dll
Regsvr32.exe C:\progra~1\common~1\system\ado\Msado15.dll

References:
http://support.microsoft.com/?id=167591
http://support.microsoft.com/?id=833220

Special Note: KB 833220, as currently written, contains an error in the long
path examples for registering DAO360.dll and MSADO15.dll. You will get the
following error if you use the commands shown in Method 1, section 2 of this
KB article:

LoadLibrary("C:\Program") failed - The specified module could not be found.

To correct this error, you need to enclose paths that include spaces with
double quotes. For example, use this instead to re-register the DAO360.dll
file:

Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\Dao360.dll"

If you still cannot get the switchboard and/or wizards to function properly,
then download the MDAC Component Checker utility and run it on your PC:

http://support.microsoft.com/?id=307255


Good Luck,
Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Guest]

Hi Robert,

Any thoughts on cause?

Nothing more than you've already guessed....that the uninstall program of
some application caused these problems.

I'm glad to hear that you like the information that you've discovered at
QBuilt.com. There's been a lot of effort put into that web site by several
people!


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

:

Tom,
Thanks for the reply. and you suggestion was on the money! Prior to
finding your suggestion and many hours of searching internet last night
and this morning I came across a tool at:
http://www.macropool.de/download/CSRepair.exe

This tool re-registers Jet and Mdac. I don't know anything about this
program or company... only that it solved the problem for me after I
spent a day finding many posts with the same problem but no solution.
Now watch this program install a trojan that wipes my hard drive or
steals my identity. All that I can say is that it worked great at what
it said it would do.

My biggest concern is what caused the problem in the first place. After
i posted here I remember that I also uninstalled FileMaker Developer 7
as well as 3 VB applications and one FoxPro. I had re-installed
everything except FMP, hoping that would re-install/re-register any
files that the un-installed removed. The reason I didn't re-install FMP
is because I had forgotten I had un-installed it.

Any thoughts on cause?
Thanks! robert

PS: the one upside to all this is that i fould your wonderfully helpfum
website/forums.

 

[Guest]

Hi Robert,

I'll have to check out ContentSaver when I find some spare time.

are u involved with www.qbuilt.com?

Yes.

Glad to hear that you got everything working again.


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________