Error 429 ActiveX Component and DAO360.dll

[Mark Hammer]

Puzzled here by why my Access XP app is getting the 429 error, on a Windows
XP machine.

I have re-registered dao360.dll. This happens with an mde file, one that
runs successfully on many other machines. My install file installs
dao360.dll and registers it, and I've had client uninstall and reinstall my
app, and get the same error message.

TIA for any advice or clues.

Mark Hammer
Lake Oswego, Oregon, US

[Douglas J. Steele]

429 is a pretty generic error. Is there a reason why you suspect the problem
is dao360.dll?

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

"Mark Hammer" <Ma...@AccessAdvantage.com> wrote in message
news:O7D1$%23afKH...@TK2MSFTNGP04.phx.gbl...

[Mark Hammer]

Ya Doug,

the error was happening on a Left(...) command.

and, I just got it solved:

Problem solved when I reregistered the dao360.dll in the Program
Files\Common Files\Microsoft Shared\DAO\ directory, rather than the one in
the System32 directory.

So, for anyone else who has this issue, here is the command prompt entry
which solved my problem:

regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO360.dll"

don't forget the quotes around the path.

My install program installed and registered the dao360.dll file in their
System32 folder, and that's the one I was re-registering. That didn't work,
but when I reregistered the other one, it did.

--Mark Hammer

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_gmail.com> wrote in message
news:upXbBXcf...@TK2MSFTNGP02.phx.gbl...

[Tony Toews [MVP]]

"Mark Hammer" <Ma...@AccessAdvantage.com> wrote:

>Puzzled here by why my Access XP app is getting the 429 error, on a Windows
>XP machine.

What references do you have? Run the following code and let us know
what you have.

Sub ViewReferenceDetails()

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor & "
- " & ref.FullPath
Next ref

End Sub

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

[Douglas J. Steele]

Glad you got it working, but in all honesty, you really haven't given any
evidence why registering dao360.dll should make a difference.

The Left function comes from the VBA library (C:\Program Files\Common
Files\Microsoft Shared\VBA\VBA6\VBE6.DLL), not the DAO library (C:\Program
Files\Common Files\Microsoft Shared\DAO\dao360.dll). However, since the VBA
library is the last one checked, any broken reference can cause problems
with VBA functions.

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

"Mark Hammer" <Ma...@AccessAdvantage.com> wrote in message

news:OFliznc...@TK2MSFTNGP02.phx.gbl...