Hi,
I am trying to learn how to use ADO and I am getting an error message about the connection string I am using. I adapted it from an example found in WROX's "Beginning Access 2007 VBA". All of the examples to this point have worked fine but this one hangs up on the connection string. Attached is a screenshot of the error message with the code in question.
Can you tell me if there is an error in the connection string? I found out that "DataSource" should read "Data Source", but changing it made no difference. It hangs on the line:
"cnADO.Open strConnection".
I hope I did that right!
Thanks in advance!
I am trying to learn how to use ADO and I am getting an error message about the connection string I am using. I adapted it from an example found in WROX's "Beginning Access 2007 VBA". All of the examples to this point have worked fine but this one hangs up on the connection string. Attached is a screenshot of the error message with the code in question.
Can you tell me if there is an error in the connection string? I found out that "DataSource" should read "Data Source", but changing it made no difference. It hangs on the line:
"cnADO.Open strConnection".
I hope I did that right!
Thanks in advance!
Last edited:
