Having problems doing the connection as per Chapter 5 in Access 2003 VBA. I am currently working in 2010 but using 2000-2003 format. Does 2010 no longer user Jet Drivers?

I just can't get a strconnection, have spent 8 hours, read the threads but no one has answered previous on this problem either.

I also tried it on a machine with 2003 access but could not connect. I know we should move on and upgrade to a newer version but no one wants to make the change.