Error 3163 running append query in Access 2003

J

Jon Ley

A weird Access 2003 problem. I have an append query that populates a
temporary table. When running it from certain machines (which just happen to
have Access 2003 installed) I get error 3163 - the data is too big for the
field. If however I open this query in table view, I can successfully select
all the records and copy/paste them to the temp table.

Running the same append query from Access 2002 works fine.

What's going on?!
 

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

"Field is too small ..." when running append query in Access 2003 6
Access 2002 Append Query Problems 2
Unmatched Append help 4
query field names changing to expr#: 8
Only first few records visible in table after running append query 1
Append Query in MS Access 1
Append query in Access to SQL Server 2
Append Query is not working 1

Top