|
MSAccess
- Start Access. Click Database to create a new blank database:

In the File New Database dialog box, enter a name for your database and select Create:

Under the Tables tab, select New:

-
In the New Table dialog box, select Link Table and click OK.
In the Link dialog box, pull down the Files of Type list box and select ODBC
Databases:
In the Select Data Source dialog box, switch to the Machine Data Source tab. Select the
Data Source Name previously created in the 32bit ODBC Administrator,
then press OK:

In the Link Table dialog box you have the option of which Image datasets to include
in this link. After you have chosen the necessary datasets press OK:

If you see a Select Unique Record Identifier dialog box, press Cancel (selecting a
field would cause delays in your queries):

Your Database - Tables display should now include the datasets you selected:

You can now create Queries and Reports that use the data currently stored in your Image Database.
NOTE:If you select Open or double clink on the dataset listed in the Tables display, MSAccess
will attempt to copy all of the data from the dataset to your PC. The intermediate file size is
currently limited and may not store all of the dataset. If you receive a warning about the temp file
size, please use a query to select a subset of your data.
|