Run-time error '-2147467259 (80004500)' - VBA for Access dbase update

Hey guys,

A little bit of how my set goes. First, I have an access database that stores the employee information as well as call metric goals. I use a VBA script to pull certain agents based on a few parameters into a table. What I need to happen is, if any data is changed in that same table, such as, an employees metric goal is adjusted, I need it to updated on the access database table. Here is the script I am using. I'm using Excel and Access 2013.

Please Login or Register  to view this content.

Now, I get the feeling I'm using the wrong strConn/reference in this script, like it's looking for sql and not access library. When I change something in the table, I get this gnarly error message:

Run-time error '-2147467259 (80004500)' Unrecognized database format.

Any ideas why or what I can do to make this work?

This works:

Please Login or Register  to view this content.

However, is there a way to make this a button click-able macro that updates the entire table at once rather than have it update each time a field is changed?

Please Login or Register  to view this content.

Okay I have added the button and the code. I edited some fields and clicked the button and got this error:
"Run-time error '424' Object Required" and the debug is highlighting For Each rng In Target.Rows

Pareshj, you have been a huge help and I thank you! Honestly, I know very little of VBA and I've been at this for over 12 hours.

Here is the script I am using now, it seems to be working!

Please Login or Register  to view this content.