ADOX

ADOX - I made this program to gain as much information as possible about the objects that make an Access database. I have never tried it with other types of databases, but as it is made using ADO it should not be a problem adding some extra code to handle those ones.

By all honesty I have to say that the code was not fully implemented by me: it is based on the original code by Francesco Balena. His project was a good starting point to add more features and a slighlty more user-friendly interface.

ADOX displays information about tables , views , groups , users and procedures of an Access Database.

Here are some key features of "ADOX":

￭ Shows information about tables, views, procedures, groups and users of an Access database. ￭ Displays properties of columns, indexes, keys (for each table) and commands (for each queries) (see Figure 2 and Figure 3). ￭ Table contents are available when selecting 'em (see Figure 1). ￭ Is it possible to have a table showing the results of a VIEW: when selecting a VIEW a message box requests whether or not to execute the query. ￭ A tool is available to convert a view or a procedure into a Visual Basic procedure that returns a string containing the SQL command (see Figure 3). ￭ Source code includes the MyMsgBox form and module, the code for adding a progressbar into a statusbar and a "standard" about box fully customizable and other personal library modules.