QueryDef query hanging

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top