How 2 stop "INSERT INTO STATEMENT contains unknown" in Access 07

J

Jim Accessfan

In append queries, previous versions of Access automatically filled in fields
to append to where the target field was an exact match. This saved lots of
time and made constructing an append query accurate and fast. Access 2007
puts exact match fields in brackets " [field1]." This means you must
manually re-select the correct target field before the query will work. How
can you eliminate this re-select step and make it run like older versions?
 

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

Top