Bill,
Re-registering the DLL did it ... Thanks!
Rob
________________________________________
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
Sent: Wednesday, June 01, 2011 4:57 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: ADOX reference missing from Access 2003
Rob
I've had that reference get out of alphabetical order in the References
dialog. Try looking up near the top below the ones you already have checked.
You could try running the Repair from the help menu. If that doesn't fix it
try registering the DLL again. In Win XP it should be in C:\Program
Files\Common\System\ado\msadox.dll
If it isn't there run a search for msadox.dll
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "Rob" <roblwhitney@...>
wrote:
>
> I'm using Access 2003, and trying to use AD0X.catalog in VBA, but I get
the "user defined type not defined" error. I've looked in references, but
see no reference to "Microsoft ADO Ext. for DDL and Security libraries", or
any other references which look ADOX-ish. I've Googled ADOx and Access 2003,
and the articles I'm seeing make it sound as if the reference should be
available on my drop-down, but it is not.
>
> Do I have a broken install of Access, or is there a "magic spell" I need
to make it appear?
>
> Thanks!
> Rob Whitney
>
Tidak ada komentar:
Posting Komentar