Runtime error 424: Object required, Using MS Access 2007 and SQL Server

[Alex Anuncio]

Good day to all, may i ask for a help?

I got 10 tables on my Access database like Agent, Order, OrderDetails etc and i got this script which transfer data from local sender to our Main Database.

Before it runs very smooth front-end and Back-End is MS Access 2007. But when i try to migrate our data to SQL SERVER 2012 when i use my Utility script if transfer data ONLY FOR Employee table but when it goes to the second Table it pop up an error message "Runtime error 424: Object required"

Can you please guide me with what reference do i need to add or what to do?

Many Thanks and GOD Bless!

[TheSmileyCoder]

You need to show us your script, or we will have no chance of providing any assistance. Remember to highlight or point us the line of code causing the error to occur.

[zmbd]

When you post your code... please include a list of the table names you're transfering spelled exactly the way they are named in your database.
For at least one of the failed tables also include the field names spelled exactly the way they are named in your database.

Please remember to use the [code][/code] around your script
-z