ADOX DDL Reference

[Survane]

I recently added the ADOX DDL and Security reference to 3 databases now when I attempt to open them, they exit immediately. I try to break the code but to no avail. Has anyone experienced this?

Thanks.

 

[thornmastr]

Do you mean you set a reference to the ADO library?

What do you mean you referenced the security library. Why? What are you trying to do?
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[Survane]

I have the line :

Dim cat As ADOX.Catalog
Dim rst As ADODB.Recordset
Dim usr As ADOX.User

In order of the ADOX to work, I had to add the
"Microsoft ADO Ext. 2.5 for DDL and Security" reference to the database. Is there alternative code that can be used instead of ADOX? When I add this reference and exit the database, when I try to re-open the database, I get the message that I could not find one of the libraries.

Thanks,
Survane.

 

[thornmastr]

There are a lot of people here who consistently use ADO/ADOX. My preference is DAO, so I am probably not the best person to help you. But perhaps to get some ADO person to jump in and help you, what are you trying to do; connect to a table and do what? Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com