With local database type set to MS Access, on the Columns Order screen, I add the first item as Datetime (Parser item name = DATE_TIME_STAMP), and the second as TankTemp1 (Parser item name = AutomationDirect.KEPDirect.V5.Temp1). The database starts sucessfully with a table named SERIAL_DATA, which has two fields named Datetime Stamp, and OPC item.
If I add a third item named Temp2 (Parser item name = AutomationDirect.KEPDirect.V5.TankTemp2) the database field is create but it has no table. Instead I get an error: Local database Could not write to file (Cannot define field more than once). It seems to me that the local db module has a bug that tries to set all field names to OPC item. Is this correct or am I doing something wrong?
Could you please, create a backup of your current configuration (from the "File" menu) and attach it here? I'll verify it.
OK here it is....
The problem with duplicate columns has been fixed. Please, download the update here:
http://www.aggsoft.com/download/localdb.exe
Also, I would recommend to make the following changes:
1. In the OPC group settings disable the "Add server name" option (because the access doesn't allow long names).
2. In the "Local database" plugin change parser names to new values (without the server name).
Great. Thanks a lot.