KB-14572: Error: Table structure can’t be generated in the Database.

Question:

After configuring the fields, the data server (Access), and table name in a historic, I click Generate Table and the following error message is displayed:

    Table structure (title of the error window)
    Table structure cannot be generated in the Database.

The following message was returned by the Database:

    ErrorLocal = Create Table Error
    Error #0x80004005
    Description: Excessive number of fields defined
   (Source: Microsoft JET Database Engine)
   (SQL State: 0190)
   (NativeError: -68092944)

How can I fix this?

Solution:

Access databases accept a maximum of 255 fields. This means E3’s historic will accept no more than 127 fields (127 fields + 127 quality fields + 1 E3Timestamp). In this example, you will have to split the historic in two (2 tables).

Print Friendly, PDF & Email

Este artigo foi útil? Was this helpful?

Classificação média - Average rating 0 / 5. Count: 0

Deixe seu Comentário

Seu endereço de e-mail não será publicado. Campos marcados com asterisco são obrigatórios *