Background Processing
y770
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
John Spencer
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" <y7...@discussions.microsoft.com> wrote in message
news:362C368F-C3ED-4319...@microsoft.com...
Marshall Barton
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.
--
Marsh
MVP [MS Access]
y770
> loop so that the procedure allows other processes to grab some processing
> cycles.
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.
y770
> procedure.
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
Tony Toews [MVP]
>I need to refresh links to external Database on the start of Access.
>This process takes time (10 - 15 secs).
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/
y770
"Tony Toews [MVP]" wrote:
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?
Tony Toews [MVP]
>> >I need to refresh links to external Database on the start of Access.
>> >This process takes time (10 - 15 secs).
>>
>> 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.
>
>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?
Could you post your code?
y770
I found how to save the password into the linked tables, so I do not need to
refresh links after all.
Sorry.
y770.