Kepware Knowledge Base: Solution
Is There a Limit on the Number of Characters That Can Be Used to Create Column Names in MS Access?
Last Update: 11/7/2018
Yes, there is. For the limitations that apply to MS Access for XP and higher according to Microsoft, refer to the table below.
Component | Maximum Size |
---|
Table Name | 64 Bytes |
Column/Field Name | 64 Bytes |
Columns/Fields Per Table | 255 |
Note: Unfortunately, problems with column names and character counts will not be detected when the table is created; the names will simply be truncated. Errors will be returned as a query failure when the DataLogger project goes into Runtime. The error "Unable to query recordset on Log Group 'KT' (Reason: 'sp_cursor: The value of the parameter 'value' is invalid')" will be returned. To resolve this error, recreate the table and edit the automatically-generated column names. Then, map the server tags to the new columns.
©
2022
PTC Inc. All Rights Reserved.