L
Lon Parisi
I am in the process of converting all my hard-coded query
strings to use bound variables. We other users try to use
the Excel sheets with the bound variable routines, Excel
seems to freeze.
Here are the changes I made, in general...
OLD
==============
1. Use OpenDatabase to create connection.
2. Use OpenRecordset method from Database object.
NEW
===============
1. Use Createworkspace and OpenConnection methods to
create connection.
2. Use CreateQueryDef method to create bound variable query
3. Use Parameters method to set bound variable values
4. Use OpenRecordset method from QueryDef object.
The old way works on everyone's machine. The new way is
not consistently working. Does anyone have any idea why
this would be happening?
Thanks,
Lon
strings to use bound variables. We other users try to use
the Excel sheets with the bound variable routines, Excel
seems to freeze.
Here are the changes I made, in general...
OLD
==============
1. Use OpenDatabase to create connection.
2. Use OpenRecordset method from Database object.
NEW
===============
1. Use Createworkspace and OpenConnection methods to
create connection.
2. Use CreateQueryDef method to create bound variable query
3. Use Parameters method to set bound variable values
4. Use OpenRecordset method from QueryDef object.
The old way works on everyone's machine. The new way is
not consistently working. Does anyone have any idea why
this would be happening?
Thanks,
Lon