Dim cat As New ADOX.Catalog 1

[cfriedberg2]

Dim cat As New ADOX.Catalog

When I use this code, I get the error message "Compile error: User-defined type not defined."

What do I do to correct this?

 

[kjv1611]

Sounds like you need a reference in VBA set..

Tools
-->References

Not sure which one you'll need, as I've not used any ADOX before... maybe [blue]Microsoft ADO for security...[/blue]?

 

[kjv1611]

Yeah, I'm pretty sure it's the one I put in blue... try it out.

 

[PHV]

Microsoft ADO Ext. 2.# for DDL and Security

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886