Background Processing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to refresh links to external Database on the start of Access.
This process takes time (10 - 15 secs). In meanwhile, I would like to
display spalsh screen with some animation (kind of a progress bar). I have
worked out all the details of this aniamtion, the only probelm left that
while the links are being refreshed my spalsh screen displays only as a
frame, with transparent background. It seems like the link refresh process
takes too much of my system resorces.
Therefore, is my question. How can I make that process (link refresh)
background process? I understand, it will run a bit longer, I am OK with it.

Y770
 
If your refresh links process is using a loop, try adding DoEvents into the
loop so that the procedure allows other processes to grab some processing
cycles.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
y770 said:
I need to refresh links to external Database on the start of Access.
This process takes time (10 - 15 secs). In meanwhile, I would like to
display spalsh screen with some animation (kind of a progress bar). I have
worked out all the details of this aniamtion, the only probelm left that
while the links are being refreshed my spalsh screen displays only as a
frame, with transparent background. It seems like the link refresh process
takes too much of my system resorces.
Therefore, is my question. How can I make that process (link refresh)
background process? I understand, it will run a bit longer, I am OK with it.
Click to expand...


Try sprinkling a few DoEvents throught your relinking
procedure.

Also check
http://www.granite.ab.ca/access/splitapp/details.htm
for ideas on how to speed up the relinking process.
 
If your refresh links process is using a loop, try adding DoEvents into the
loop so that the procedure allows other processes to grab some processing
cycles.
Click to expand...

I do not have a loop, as I need to relink only 5 tables. Out of those 5 only
2 or 3 takes some significant amount of time. I will try to insert DoEvents
in the middle of the relinking. Thank you very much.
 
Try sprinkling a few DoEvents throught your relinking
procedure.
Click to expand...
I did it and it helped somewhat. Now I see my splash screen, and I also see
my progress bar.
Progress bar populates based on the timer value. If the timer gets over max,
I reset it to 0 and start it again. However, due to the fact that doEvents
pass the control to this form only a few times, the progress bar populates
only 2 or 3 times.
I really need to send relinking into the background, then timer will operate
properly.
I just do not know how to do it.

But thaks for your help. At least I am onthe right direction.

y770
 
y770 said:
I need to refresh links to external Database on the start of Access.
This process takes time (10 - 15 secs).
Click to expand...

Once you've relinked the first table then open a recordset against
that table. Now relink the rest of the tables and then close the
recordset. You should see it go much, much faster.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Tony Toews said:
Once you've relinked the first table then open a recordset against
that table. Now relink the rest of the tables and then close the
recordset. You should see it go much, much faster.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Click to expand...

For some reason it did not help. As a matter of fact I timed re-linking of
each table separately and found that big (many records) tables take longer to
re-link (obviously). However, when I looked into the table itself I've found
that 'big' tables are not that big at all. One of them are approx. 9000
records, and other is just 827 records. I don't think it should take more
then 4 sec to link 827 records. I've re-indexed that table just yesterday and
it did not help.
What else can I do?
 
y770 said:
For some reason it did not help. As a matter of fact I timed re-linking of
each table separately and found that big (many records) tables take longer to
re-link (obviously). However, when I looked into the table itself I've found
that 'big' tables are not that big at all. One of them are approx. 9000
records, and other is just 827 records. I don't think it should take more
then 4 sec to link 827 records. I've re-indexed that table just yesterday and
it did not help.
What else can I do?
Click to expand...

Could you post your code?

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Thank You for the help.
I found how to save the password into the linked tables, so I do not need to
refresh links after all.
Sorry.

y770.
 
Back
Top