Run-time Error '429' ActiveX component can't create object
Hi. That's strange. Because in Access97 you don't have that specific problem
with ADO and DAO.
Could you include a piece of your code?
I check it tomorrow for you.
Now it's time to go asleep. (Other continent....probably)
-Arjan-
Quote:
> I understand
> but then I'd have to change it everywhere in the database, and that is
time
> consuming, even if I do a Find/Replace method
> The strange thing is that the line in yellow executes fine on other
> computers with the exact same database.
> It is Access 97
> ??
> > It has probably to do with the reference. You don't mention in which
> version
> > you have this problem.
> > But try this:
> > Dim db as DAO.database
> > Because when you have Access 2K or XP the 'database' object could refer
to
> > ADO or DAO.
> > -AJ-
> > > When my database loads I get this run-time error:
> > > ActiveX component can't create object
> > > When I click "Debug" the line that is highlighted in
> > > yellow is:
> > > Set db = OpenDatabase(MyDatabaseName)
> > > The above line is used several places throughout the
> > > database. The error only occurs when it loads, only one a
> > > few computers. The exact same database loads fine on
> > > other computers.
> > > I installed the Regsvr32.exe
> > > And then I typed this at a command line:
> > > RegSvr32 C:\progra~1\common~1\micros~1\dao\dao350.dll
> > > Just as I was instructed to by a seprate response to a
> > > similar reporting of this error.
> > > I restarted the computer, and tried to load the databse
> > > again, and still go the error.
> > > What do I do now???
> > > (....puzzling....)
