VBA to Access Database connection

Hello everyone,
I am trying to teach myself how to connect to an access database via excel VBA. Can someone explain to me why I am getting an error in this code.
The first sub works no problem.
The second sub will work if I uncomment out the first query and comment out the second. But I want to put the database path in a variable because not all computers in our office are mapped the same, so the "C" drive maybe a different letter on another computer. (Take the 'C" drive as a representation of our server drive).

When I create the variable 'DBPath' and run it, I get an run-time error 1004 when it hits the last line of the with statement (.Refresh BackgroundQuery:=False) and I do not know why.

Please Login or Register  to view this content.

I tried to upload a copy of the database (its only two items so I know its not overly large), but the forum would not allow it.

Thanks in advance
Ken

Try it like this. The way you had it was passing the literal text "DBPath" rather than the variable.

Please Login or Register  to view this content.

Thanks ByteMarks, I tried your suggestion but still get the run time error at the same location.

Maybe

Please Login or Register  to view this content.

Thanks ByteMarks, that worked perfectly.
If you can, can you explain why the variable has to be done that way. Like I said, I am trying to learn this so understanding the process will help alot.

Great.
You need to separate the variable DBPath from the rest of the string so that it's value (the path) is used and not the text "DBPath"

In the source the path has to be encased by ", so you need to add these before and after the variable, hence the """

It's might be easier to demonstrate with a simpler example:
Only 1 and 4 are correct.

Please Login or Register  to view this content.

Thanks for that ByteMarks, much appreciated.

You're welcome.