Threads and Database

[alex1973]

I need to do some database search with my application while the user is using it. Right now, while I access the database the user can't do anything(my application looks like is frozen). How can I use another thread to do the search?
Thanx.

[Lothar Haensler]

IMHO you don't need to use Threads.
You can use ADO's asynchronous Execution modes to make your User interface responding to user requests.
You can execute commands or fetch records asynchronously in ADO.

[alex1973]

I've tryed but I get the message:
"The operation requested by the application is not supported by the provider".

I have an Access 2000 database and:
lConnection.ConnectionString = "PROVIDER=MSDASQL;dsn=find2;uid=;pwd=;"
Set lRS = cmd.Execute(strSQL, , adExecuteAsync)

What is wrong? Thank you again for your suggestions.

[Lothar Haensler]

>PROVIDER=MSDASQL;
IMHO that's the wrong provider for an Access 2000 database. You need to use the Jet-Provider.

[alex1973]

It works without the asynchronous execution. Are you saying that the asynchronous execution does't work with MSDASQL?

[Lothar Haensler]

NO, I was saying that MSDASQL sounds to me like the SQLServer driver of ADO.
If I understand you correctly, you are using a Jet database.
Asynchronous operations work with SQL Server.
I don't know if the Access driver supports it.

[alex1973]

How do I deal with "Could not find installable ISAM"?