Within the GIFTS system, when using a Microsoft SQL Server or Microsoft Access database back end, administrators may receive a message similar to one of the following when creating new fields with the GIFTS Customizer:
Error occurred during table creation Error occurred while executing SQL Statement: [XXX]
Technical Support Info: [SQLExecute] Error #-2147217900 Syntax error in field definition
Technical Support Info: [SQLExecute] Error #-2147217900 [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'xxx'
The reason for this behavior is tied to the fact that Microsoft SQL Server and the ODBC drivers that your GIFTS workstations use to communicate with your SQL Server database both reserve words for use in administering database information. These keywords are also reserved for use by Microsoft Access.