By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,661 Members | 1,917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,661 IT Pros & Developers. It's quick & easy.

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

P: 1
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!
Jul 19 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 100+
P: 2,321
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.
Jul 19 '12 #2

Expert Mod 5K+
P: 5,397
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
Jul 19 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.