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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Queries won't working after upgrading to 2007 3
"Compile error in table level validation expression " after format 0
update and append queries 1
My computer will print from ALL other programs except MS publisher 2007 4
Office 2007 converted to 2010 by security update and won't open 0
O-2003 mdb with O-2003 and O-2007 users 1
where is the security file located in 2007? 1
MSAccess 2003 mdb file does not work well in MSAccess 2007 1

Top