I have Office 2000 installed on a Windows 2008 Server used as a Terminal
Server. I have several mdb's that were working fine until recently. After I
installed a program that installed Access 2003 runtime, I started getting
error 429 (ActiveX component can't create object). I uninstalled the new
program, and uninstalled Access 2003 Runtime as well, and I still have the
problem. Following is one of the lines of code that causes this:

Set rstDimsMaster = New ADODB.Recordset

I have tried reregistering DAO360.dll, uninstalling and reinstalling Office
2000, and still the error persists. Does anyone have any ideas on this?

Thanks,

Keith

Hi Chris,

Thanks for the reply. I have a dumb question...how do I reregister the tlb
file as you suggested? I tried regsvr32.exe which gave me an error because
the file is not a valid dll or ocx file.

I tried clireg32.exe which gave me the following:

'clireg32.exe' is not recognized as an internal or external command,
operable program or batch file.

I got the same thing with regtlib.exe.

Can you please help me with this?

Thanks,

Keith


"Chris O'C via AccessMonster.com" wrote:

> Reregister C:\Program Files\Common Files\System\ado\msado21.tlb
>
> Chris
>
>
> Keith wrote:
> >I have Office 2000 installed on a Windows 2008 Server used as a Terminal
> >Server. I have several mdb's that were working fine until recently. After I
> >installed a program that installed Access 2003 runtime, I started getting
> >error 429 (ActiveX component can't create object). I uninstalled the new
> >program, and uninstalled Access 2003 Runtime as well, and I still have the
> >problem. Following is one of the lines of code that causes this:
> >
> >Set rstDimsMaster = New ADODB.Recordset
> >
> >I have tried reregistering DAO360.dll, uninstalling and reinstalling Office
> >2000, and still the error persists. Does anyone have any ideas on this?
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200901/1
>
>

Chris,

Thanks for all of the info. I was able to successfully reregister
msado21.tlb. Unfortunately, my 429 error persists. Do you have any other
suggestions?

Thanks,

Keith


"Chris O'C via AccessMonster.com" wrote:

> Sorry, my bad. I didn't explain about registering a type lib. FYI, regsvr32.
> exe is a tool for registering active x controls, not type libs. That's why
> it won't work.
>
> Regtlib.exe is a component of Visual Studio .net and Visual Studio 6 sp3. If
> you don't have either of these dev tools you can download the file from
> Microsoft (or google for it).
>
> http://support.microsoft.com/kb/197298
>
> Or you can use the RegisterTypeLib or RegisterTLB Windows api function in a
> vba procedure to register a type lib:
>
> Declare Function RegisterTypeLib Lib "oleaut32.dll" (ByVal pTLB As Object,
> szFullPath As Byte, szHelpFile As Byte) As Long
>
> or
>
> Declare Function RegisterTLB Lib "vb6stkit.dll" _
> (byval lpTLBName as string) as Integer
>
> See msdn and Randy Birch's site for documentation.
>
> http://msdn.microsoft.com/en-us/library/ms221570.aspx
>
> http://vb.mvps.org/hardcore/html/uni...ifunctions.htm
>
> Example usage:
>
> http://www.vbaccelerator.com/home/VB...ypeLib_bas.asp
>
>
> http://www.vbaccelerator.com/home/VB...ty/article.asp
>
>
>
> Chris
>
>
> Keith wrote:
>
> >Thanks for the reply. I have a dumb question...how do I reregister the tlb
> >file as you suggested? I tried regsvr32.exe which gave me an error because
> >the file is not a valid dll or ocx file.
> >
> >I tried clireg32.exe which gave me the following:
> >
> >'clireg32.exe' is not recognized as an internal or external command,
> >operable program or batch file.
> >
> >I got the same thing with regtlib.exe.
> >
> >Can you please help me with this?
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200901/1
>
>

Chris,

The Component Checker doesn't work in Vista and newer OS's (like Windows
Server 2008).

I'm actually considering going a different direction and removing Office
altogether from the Terminal Server and replacing it with Access 2007 runtime.

Anyway, if you have any other ideas, please let me know. Thanks again for
all of your efforts.

Keith


"Chris O'C via AccessMonster.com" wrote:

> Download and install the mdac component checker to check your mdac
> installation libraries and files.
>
> http://www.microsoft.com/downloads/d...displaylang=en
>
>
> Chris
>
>
> Keith wrote:
> >Chris,
> >
> >Thanks for all of the info. I was able to successfully reregister
> >msado21.tlb. Unfortunately, my 429 error persists. Do you have any other
> >suggestions?
> >
> >Thanks,
> >
> >Keith
> >
> >> Sorry, my bad. I didn't explain about registering a type lib. FYI, regsvr32.
> >> exe is a tool for registering active x controls, not type libs. That's why
> >[quoted text clipped - 43 lines]
> >> >
> >> >Can you please help me with this?
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...dules/200901/1
>
>