Use the search feature to view Kepware's repository of more than 500 Knowledge Base articles. Narrow your results or type your query into the search field below.

Alternatively, if you are unable to find a solution, we have an additional resource - our PTC eSupport Portal . If you are prompted to log into the eSupport Portal, you can use your My Kepware credentials. Need a My Kepware account? Create one here .

Search Solution Results By:
View All Solutions

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.

ComponentMaximum Size
Table Name64 Bytes
Column/Field Name64 Bytes
Columns/Fields Per Table255

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.

Related Products