The table defined has 3 fields and works as expected.
However if the name of the field is changed to a SQL reserved e.g. “Exit”, you will get the following error when opening the table
Cannot select a record in Table1 (Table1).
The SQL database has issued an error.
SQL error description: [Microsoft][SQL Native Client][SQL Server]Incorrect syntax near the keyword ‘EXIT’.
SQL statement: SELECT A.INTFIELD,A.NOYES,A.EXIT,A.RECVERSION,A.RECID FROM TABLE1 A WHERE (DATAAREAID=?) ORDER BY A.DATAAREAID,A.RECID OPTION(FAST 1)
For a full list of reserved words please refer to the version of SQL you are using