B&B Electronics MODSCAN32 - Manual - Manual (Page 43)

43
Database Operation
An optional feature of ModScan32 allows you to write data directly into a Microsoft compatible database
such as Access. ModScan uses the Jet database engine to provide an efficient exchange of information from
an addressed slave device into the designated database table. Selecting the Dbase Capture menu item
allows you to associate a ModScan document with a given database table. The table will then be updated
with new data each time the slave device is polled. If you change the properties of the document while
collection is enabled, updates to the database will temporarily cease. Database updates will resume if the
original properties are restored.
ModScan attempts to write the modbus data associated with a particular document as a linear table
consisting of the time, status code, and value for each defined point. The table is created with the number
of columns equal to the number of points selected in the active document plus two additional fields to
contain the time & date and the status code associated with each reading. Table headers to identify each
column consist of the 5-digit modbus address for each data point. For example, a table defined to contain 5
input registers beginning at address 44 would look like:
Time
Status 30044 30045 30046 30047 30048
11/5/97 12:53 P.M. 0 0000 0001 0002 0003 0004
11/5/97 12:54 P.M. 0 0000 0001 0002 0003 0004
11/5/97 12:55 P.M. 0 0000 0001 0002 0003 0004