ADOX???

  • Thread starter Thread starter Jens
  • Start date Start date
J

Jens

Hello,
I have a question that is really stumping me. I am
programming a report in access that will only allow
certain users in a special group to open it. On the
Report_Open() function, I am writing some code (that was
generously provided by someone on this site) that will
serach through the groups and check to see if they are in
the group that can print or can't print. Anyway, the
first line is declaring a variable:

Dim cat As New ADOX.Catalog

What is ADOX?? I know it has to do with ActiveX, but when
I am writing the code, it doesn't know what it is. I get
two option ADODB or Access. Do I need to install
something? ANy help would be greatly appreciated.

Thanks,
Jens
 
ADOX seems to be an extension set of objects for use with
an ADO database. There should be an ADOX reference in your
list to include. Add that reference and the ADOX features
are available. I recently found myself using the same
tools and ADOX was necessary to get at the structure of
the database.

hth,
Jerry
 
Jens / Jerry:

ADOX is technically what is used for "Data Definition Lanaguage" actions on
databases. DDL is what is used to create tables, queries, views and other
data oriented objects (not forms or reports which are Access objects)
contained within a database which is called a "catalog". The reason that
there are two libraries, i.e. ADO and ADOX is that ADO (an interface to
query and update data within the data objects) is used by lots of data
"clients" or consumers like web services as well as Access and other data
aware applications. By not including the DDL functions with ADO proper, it
makes that interface lighter and faster as well as providing a measure of
security in apps that are public.
 
Back
Top