I had several forms that entered data into a field labeled "Position".
The Position data came from a lookup table. Neither table is related
to any other table. They all worked fine.

Now none of them insert a record, they all produce an "Error in INSERT Statement"
If I IGNORE the field Postion in the form it updates fine with no error.

- I have rebuilt the datafile..no help still get an error with Position active
- I have deleted the field Position and recreated it with no data..still get an error with Position active
- I have rebuilt the lookup table..no help still get an error with Position active
- I have removed the insert behavior, saved the form and reinserted the inset behavior.
- I have created a form with ONLY the Position drop down menu..still get an error with Position active
- I have checked for special characters or spaces in the name...not the issue
- I have checked and Position doesn't seem to be on the reserved word list
(support.microsoft.com/default.aspx?scid=kb;%5BLN%5D;Q286335)

If I rename the field to DesiredPosition the original form and the new form work fine.

What could have happened that caused inserting data into the field Position to behave like
it was a reserved word???

Windows XP Pro
Dreaweaver MX v6.1
MS Access 2002 (10.4302.4219) SP-2
IIS 5