Table and Column Restrictions

Table and column names should not begin with a number.

Table names should not start with the letters lu.

Table and column names cannot match the reserved words of SQL. A list of reserved words can be found at http://msdn.microsoft.com/en-us/library/ms189822.aspx

Table and column names should be less than 64 characters long.

Table and column names should not contain a period (.), exclamation point (!), accent grave (`), pipe (|), single quote (‘), double quote (“), comma (,), asterisk (*), colon (:) or square brackets ([and]).

Table and column names should not lead with a space.

The column name DateAndTime is a reserved name. If you use this as a column name you will not be able to modify or delete it once the table is created.

A table should have no more than 127 columns configured as only 127 columns can be updated at one time.

The database is restricted to 2GB in size. Once this limit is reached no more records may be inserted to the database until records are purged.

Support for accdb database requires the appropriate Microsoft Access Database Engine OLE-DB provider.