Run Time Error 3825 - Sync Remote Database in Microsoft Access


	Back to Sync Remote Database Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Run Time Error 3825

Thomas Corbett

18 months ago

Hi, I was hoping someone else has run into this error "Select * cannot be used in an Insert into query when the source or destination table contains a multi-valued field"

I am using the Silver Cut with two tables, one works fine the other generates this error.

Thanks

Tom -

	Richard Rost @Reply 18 months ago
Yet another reason to avoid Multivalued Fields. They're evil. You'll have to SELECT all of the fields manually EXCEPT that MVF.

	Thomas Corbett OP @Reply 18 months ago
I have deleted the only field which I believe to be multi-valued and I am still getting an error :(

	Sami Shamma @Reply 18 months ago
If you're still getting the same error, that means there are still some remnants in your database Do a compact and repair. If necessary, go down the list ofTroubleshooter

	Thomas Corbett OP @Reply 18 months ago
I deleted all fields from the table except the random auto number and the date field and the error persist

	Richard Rost @Reply 18 months ago
Damn. You might need to create a new table that's identical to the old one but without the MVF. Use an append query to copy the records over. Then try working with that table.

	Richard Rost @Reply 18 months ago
Also make sure the DESTINATION table doesn't include an MVF as well. Also don't use the *. Manually pick the fields.

	Thomas Corbett OP @Reply 18 months ago
Thank you guys, this was a head scratcher! I did all the proper troubleshooting with no prevail so I started deleting the the fields one at a time. As I came deleted one of the number fields the issue went away. Weird Science!!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Sync Remote Database.

Next Unseen