Re: defined type

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

You need to add a reference to ADOX.

With any module open (and no code running), select Tools | References from
the menu bar. Scroll through the list until you find the entry for Microsoft
ADO Ext. 2.x for DDL and Security (x will vary), select it, and close the
dialog.

Alternative, you could try using Late Binding. That would mean changing your
declaration to

Dim cat As Object

and adding a line

Set cat = CreateObject("ADOX.Catalog")

Of course, if you've got other ADOX objects declared or if you're using
intrinsic ADOX constants, it's probably easier to add the reference.


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


"Florin" <florin_serban@xxxxxxxxxxx> wrote in message
news:%23cT7gUneGHA.2188@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

In my first function in Access97 , I get the errors:

"User - defined type not defined"

for cod line: "Dim cat As New ADOX.Catalog"
(function loads the LinkedTables array)

What can I do?

Thanks




.

Relevant Pages

  • RE: Access Field Types
    ... I have reviewed the newsgroup and find that you have post a similar post in ... I think Gary's suggestion in the group above that to use the ADOX to do the ... right click on the reference in the solution explorer and select add ... Microsoft Online Partner Support ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Access Field Types
    ... Best Regards - OHM ... > Also because ADOX is an COM object we can use it in .NET easier by simply ... > adding reference to the ADOX library and the VS.NET will generate the ... > Microsoft Online Partner Support ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to Manipulate Uses and Groups (MS Access) in VB.NET
    ... Thanks Chris. ... two that was .NET and they said to add ADOX as a reference, ... If anyone knows how to do this or where some documentation is, ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Evaluating References in Code [Long]
    ... I've got an adp with a reference to another adp ... Metrix has an older version of ADOX, ... The client machine has a reference to ...
    (comp.databases.ms-access)
  • ADOX problem / VB6
    ... I'm getting 'Record too large' error when trying to append columns using ... ADOX for any table with> approx. ... DIM cat As ADOX.Catalog ...
    (microsoft.public.vb.database.ado)