Access 2010 with an SQL Server 2008 R2 backend, all tables linked to backed using DSN Less odbc connections.
All working well but when I want to run two different queries on the same table in one module it hangs and say's odbc connection timeout on the second query.
Example
Simple example but hopefully you get the picture.
How can it be done?
I don't need them open at the same time so am I happy to close connection one then open connection two but I can't figure that one out either
All working well but when I want to run two different queries on the same table in one module it hangs and say's odbc connection timeout on the second query.
Example
Code:
Set x = db.OpenRecordset("SELECT * FROM Table1 WHERE Field1 = 'A'")
Set y = db.OpenRecordset("SELECT * FROM Table1 WHERE Field2 = 'B'")
Simple example but hopefully you get the picture.
How can it be done?
I don't need them open at the same time so am I happy to close connection one then open connection two but I can't figure that one out either