This topic describes how to customize FORMS to save field information in a Microsoft Access database. The sample code is abbreviated for simplicity. All error handling has been removed. In some cases, code has been grouped together, though a more effective implementation would have had the code more spread out for better performance.
Start Microsoft Access and create a new database called C:\DB\Sample.mdb.
Create a table named "Field" containing all the fields shown in the table above.
Start Microsoft Visual Basic version 5.0 and use the project creation wizard to create an ActiveX DLL project called "Sample". In the dialog, make sure that is checked. This tells VB5 that code for accessing Microsoft Access is to be included in the project. If the line does not appear, it is probably because Microsoft Access version 8.0 is not installed in your system.
Enter code that inserts data into a database (sample code).
Build the project and copy the resulting DLL to the program directory, normally C:\Program Files\ReadSoft\FORMS\Bin.
Register the DLL using the REGSVR32 C:\Program Files\ReadSoft\FORMS\Bin\Sample.dll command (assuming that you named the DLL "Sample.dll").
Use the FORMS Manager module to create one or more form definitions.
Use Manager to create a job description which includes the form definitions defined in the previous step. Define event handlers for the JobStarted (sample code) and JobStopped (sample code) events.
Run the job in Scan and Interpret (or only in Interpret if you are importing image files).
Start Microsoft Access and ensure that the information was inserted into the "Field" table.
A different example: Routing forms to queues