Quote Originally Posted by Ecniv View Post
I think your inital code should work except that the path has to be the path the computer uses not the nice one that windows says.. ie if you have any spaces in the path I dont think it would work...

Easy to test though.. if you have a dev folder on your c drive, it should connect to that.

Use the break point debugging (on the column to the left of the code, click once, a ball should appear and the line highlights). When you execute the code pauses at that breakpoint and you can use the immediates window (ctrl+g) or hover over the variables to confirm that values are correct.
The path I'm using is the actual path, including the database file - "E:\Projects\MyApp\MyDb.accdb"