Database Exchange control supports two drivers:
Be aware that the schema of an Access database retrieved by Database Exchange is grouped into a table list and stored procedure list.
The table list includes the following objects:
The stored procedure list includes the following objects:
For instance, assume that there is a parameterized query in your Access database and its SQL statement looks like
WHERE (((AlarmSummary.OnDate) Between [Date1:] And [Date2:]));
This query has two parameters, Date1 and Date2. Be aware that the field OnDate is a Date/Time type. If you want to retrieve data between 10/10/2003 and 11/10/2003, you should enter
into the parameter field on the Database Exchange Properties dialog box.
Note: You need Version 3.1.1 or later of Database Exchange control to support Access parameterized queries with Jet OLE DB Provider only.