検索機能を使用して 500 を上回る Kepware の知識ベース記事の中から閲覧します。結果を絞り込むか、クエリーを下部の検索フィールドに入力します。

解決策が見つからなかった場合には、当社の PTC eSupport Portal で追加資料を確認することもできます。eSupport Portal へのログインを要求された場合、My Kepware の認証情報を使用できます。My Kepware アカウントが必要ですか? こちらで作成

各種検索方法:
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: 2018/11/07

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
DataLogger