Thank you very much for your reply. I have had success connecting this way and there are examples in this book that does it in just this way.
Since I'm in a learning mode I was wondering how to do this by bypassing the Jet database engine. I have referenced the the Microsoft ADO Ext. 2.8 for...
I bought this book for Access VBA programming primarily to refresh my knowledge and learn some new stuff. I am currently try to learn how to use DSN-less connections. None of the examples work for me. I keep getting the "Data source name not found error".
Here is the code I'm using to...