Sorry, I am new to this forum. I clicked submit by accident, and before I knew it... my post had gone up without me asking my question. The above code has 2 problems:
• First, there should have been over 10,000 results returned from the query. When I run the query, it only takes about 2...
Sub dbconnect3()
Dim wkrJet As DAO.Workspace, wrkODBC As DAO.Workspace
Dim conODBCDirect As DAO.Connection
Dim rsODBCDirect As DAO.Recordset
Dim strConn As String
strConn = "ODBC;DATABASE=dbname;UID=username;PWD=password;DSN=dbname;LOGINTIMEOUT=50;"
Set wrkODBC =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.