MakeCustomerBackUpQ Error Message - Microsoft Access Expert 17


	Back to Access Expert 17 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

MakeCustomerBackUpQ Error Message

John Jira

15 months ago

Richard,

For some reason I am receiving the error message "Muilti-valued fields not allowed in SELECT INTO statements." when running the MakeCustomerBackUpQ. Vicki Hudson also received this error and I don't think she received a helpful response to this problem. I downloaded the DB just to check the customer table with the one I have and both are the same.

John J

	Kevin Robertson @Reply 15 months ago
Multi-valued fields: Evil Access Stuff Is this the database from Expert 17? I just checked and there are no multi-valued fields in CustomerT.

	John Jira OP @Reply 15 months ago
Yes, there NO multi-valued fields in CustomerT and yet error message pops up. I am stump.

	John Jira OP @Reply 15 months ago
I changed the hyperlink fields to short text and still receive the error message. Very confused!!

	Richard Rost @Reply 15 months ago
Does this happen in my copy of the database?

	John Jira OP @Reply 15 months ago
No it doesn't.

	Richard Rost @Reply 15 months ago
Okay, well, that helps us narrow it down. What I would recommend doing is starting with a copy of my database and then retracing your steps one at a time. Add back in the changes that you made to the database for your purposes, and then that should indicate or at least help you figure out where the problem was introduced. Any complex data type could cause that error message.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 17.

Next Unseen

New Feature: Comment Live View