Navigation:  Samples >

Explorer Sample

Previous pageReturn to chapter overviewNext page

This sample is an Explorer like program that allows you to open and explore Access.MDB files, and look at the properties of all objects in these database files. You can examine table definitions, query definitions, relations, indexes and fields, and you can also look at (some of) the data that's in the table.

Please check the following options:

·By default when you have a TableDef or Querydef object selected in the treeview, you'll see its properties in the listview. When you select the View/Show Data menu item (or toolbar button) you'll see the first 50 records of the table in the listview part of the explorer.
·If you have defined Lookup information in Access (to show a Combobox with a description of a related record in stead of the foreign key value) you'll see the correct information in the listview (Orders table)
·You can open more than one database and explorer them
·Do no press Expand all when you are at the root item of the tree, unless you are prepaired for a long wait. The program will read all the information from the database, and that may take a long time !
·We have included the Jet Debugger to show you how to use it in your application