Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms Programming / October 2005

Tip: Looking for answers? Try searching our database.

AxtiveX error message, help needed

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mscertified - 31 Oct 2005 18:03 GMT
I'm getting the following error message "Run time error 429 - ActiveX
component can't create object". The following is the command it fails on:
Set mclsFO = New FileObject

Does anyone have any idea what this message means?

This is an application that worked fine before I was upgraded from Access
2000 to 2003.
Douglas J Steele - 31 Oct 2005 18:21 GMT
Assuming you mean FileSystemObject, did you set a reference to scrrun.dll?

To avoid needing to set the reference, you can use late binding.

Rather than:

Dim mclsFO As FileSystemObject

  Set mclsFO = New FileSystemObject

use

Dim mclsFO As Object

  Set mclsFO = CreateObject("Scripting.FileSystemObject")

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I'm getting the following error message "Run time error 429 - ActiveX
> component can't create object". The following is the command it fails on:
[quoted text clipped - 4 lines]
> This is an application that worked fine before I was upgraded from Access
> 2000 to 2003.
'69 Camaro - 31 Oct 2005 18:30 GMT
> Does anyone have any idea what this message means?

It means that the library that carries the definition for FileObject is not
available in Access 2003.  What library were you using in Access 2000 for
this class?  It's not in the default libraries, or even the most common
libraries that aren't the defaults.  (There's a FileSystemObject class in the
Scripting library (scrrun.dll), but that's not the same thing).

You may need to re-register this Active-X control.  Look in the References
and see whether there are any libraries marked "MISSING:" and if so, look at
the path and file name.  Use this path to re-register the library in the
Windows Start -> Run dialog window.  For example, if it were the DAO library
that needed to be re-registered, it would be:

Regsvr32.EXE "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.DLL"

You say you were "upgraded from Access 2000 to 2003."  Was that just a
removal of Access 2000 and an installation of 2003, or was that a new image
on your computer?  If it's the latter, then the library defining FileObject
may not even be on your current computer any more.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers.  Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

> I'm getting the following error message "Run time error 429 - ActiveX
> component can't create object". The following is the command it fails on:
[quoted text clipped - 4 lines]
> This is an application that worked fine before I was upgraded from Access
> 2000 to 2003.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.