More Threads.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Scott Burke - 27 Sep 2006 20:19 GMT

I was trying to increase the number of threads that a program uses.
I thought this would do it.
application.setoption "Threads", 10

This give me an error. What is the correctly way to increase the number of
threads. via VBA.

Scott Burke

Reply to this Message

Douglas J. Steele - 27 Sep 2006 20:30 GMT

AFAIK, Access is single-threaded. I believe most database applications are.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I was trying to increase the number of threads that a program uses.
> I thought this would do it.
[quoted text clipped - 5 lines]
>
> Scott Burke

Reply to this Message

Scott Burke - 28 Sep 2006 14:25 GMT

Access help file says that Access defaults to 3 threads. You can change it
in the registry or programmiclly. I perfer the program option my self.

The catch. The help file does NOT tell how to change the threads but it
does show you how to change other options.!?

Scott Burke

> AFAIK, Access is single-threaded. I believe most database applications are.
>
[quoted text clipped - 7 lines]
> >
> > Scott Burke

Reply to this Message