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.