The Database tab allows you to setup Art-Copy to save a scanned images to an access database.
- Database Connection:
- First you must decide if you will be using a standard Microsoft Access database or a more advanced database (such as MS SQL). Select the appropriate database selection radio button, which will then activate the needed areas of the form.
- Microsoft Access Database:
- This will hold a fully qualified path to your Microsoft Access database (c:\myfolder\mydb.mdb).
- DSN Database:
- This will hold the DSN name setup using Microsoft's Data Source (ODBC) option within the Windows Control Panel. If your DSN connection requires a User Name and Password, check the "Requires Login" from the Database Login options and enter both the User Name and Password in the appropriate text fields.
- Table Name:
- You will also need to enter the name of the table that you want Art-Copy Scripting to save into. The table must be in the database you entered above. Please note that the table name is case-sensitive.
- Primary Key Field Name (Optional):
- The "Primary Key" field name will allow the user to specify a specific primary key column name in order to save data directly to a specific row identified by its primary key. To enable this option you must check the "Ask for insertion into specific record" option in order to bring up the "Primary Key" selection dialog after the successful scan operation just before insertion into the database. This "Primary Key" dialog will contain a text area for the user to insert the Primary Key value, such as an invoice number or social security number, for the program to insert into the database at that specific record.
- Image Column Name:
- You also must enter the column name that you want the image saved in. This column must be in the table you entered above.
- Image Column Data Type:
- You can select one of four different data types to save the image as.
Link - This datatype saves the location of where the image is located as a Hyperlink. For this datatype to function correctly you must save it as a Hyperlink in your database. If you do not want to link to the location, use the Plain Text datatype.
Binary Data - This datatype saves the image in binary data. This is not recommended for casual users because it is hard to retrieve the data.
OLE Object - This datatype saves the image as an OLE Object, so you can open the image from the database. This is not recommended because of the size overhead involved.
Plain Text - This datatype saves the location of where the image is located.
- Default Description:
- If you include a description, and do not select the check box to "Ask for the description after the scan", you will need to enter a default message. This message will be used whenever you include a description, and one is not entered after the scan.
- Ask for description after scan:
- If you include a description, there are two way to enter the description. You can select this check box to enter the description after you scan in the image, or you can use the default description text area.
[Return to Contents]
|
