Update Queries won't work after upgrading to 2007

K

Karri

After upgrading to 2007 from 2003, the update queries won't work. Gives me
message – “Compile error. in table-level validation expressionâ€

I decided to run the same queries directly in the back-end database. They
ran and update the tables with no errors.

I do have a front-end and back-end database. Both are in 2007 format. The
file locations have been added to the Trusted Locations area and are actually
in the same folder for testing purposes.
 
Top