multi thread application

[iccsi]

Some of the reports in my database takes long time to get result.
User is unbale to do other thing when MS Access generate report.

I just wonder does MS Access support multi thread that I can running
the report in the backgroud that users still be able to do enter data.


Your information is great appreciated,

 

[Ron2006]

Possible workaround.........

Create two copies of the app on the local machine i.e. "app1.mdb"
and "Copy of App1.mdb"

One user can execute both "versions" and do the report from the report
version and still do input or whatever via the second version. (This
will be true ONLY to the extent that the reports will not be scewed or
incorrect if they do not have all the records available. By that I
mean as the report is being produced a new record may be added and it
would NOT be listed in the report or may be listed depending on where/
when in the process the queries for the report review/capture the
information and the record is added.)

This is almost the same as if a separate dedicated machine was running
the report and you were allowing other users to add data while the
report was running.

However, if the machine running the two versions is not a race horse,
there will be some degredation in performance.

Ron

 

[Jeff Boyce]

There can be many reasons why a report runs long.

If you'll provide a bit more specific description of your situation, folks
here may be able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[iccsi]

There can be many reasons why a report runs long.

If you'll provide a bit more specific description of your situation, folks
here may be able to offer more specific suggestions.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.








- Show quoted text -

My application has over 600 M data and links to more than 10 backend
mdb file.
Some reports run for one to two minutes which is the normal, since the
amount of the data and calculations.

I check all indexes to improve performance.
I think Ron2006 gives me work around is good idea.

Thanks again,