429 Error

[Keith]

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

 

[Chris O'C via AccessMonster.com]

Reregister C:\Program Files\Common Files\System\ado\msado21.tlb

Chris

 

[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]

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/unicodeapifunctions.htm

Example usage:

http://www.vbaccelerator.com/home/V...eLib_Source_Code_zip_mRegisterTypeLib_bas.asp


http://www.vbaccelerator.com/home/VB/Utilities/Type_Library_Registration_Utility/article.asp



Chris

 

[Keith]

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]

Download and install the mdac component checker to check your mdac
installation libraries and files.

http://www.microsoft.com/downloads/...f6-4a21-4b43-bf53-14332ef092c9&displaylang=en


Chris

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]

 

[Keith]

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

Download and install the mdac component checker to check your mdac
installation libraries and files.

http://www.microsoft.com/downloads/...f6-4a21-4b43-bf53-14332ef092c9&displaylang=en


Chris

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?