Application & file open delay via windows explorer

[ma]

Hi there,
Sorry for long message!
I tried to find a solution by Googling to no avail.

And yes, I did post this in XP_General but I received no
replies, so please don't execute me.

Here is the challenge:
Windows XP SP2
Office 2003
Before you decide this belongs to the Office or Access NG,
please hear me out. It has something to do with my LAN.

I have an Access 2003 MDB file. OK, no problem.

I try to access this file from only one PC (the one it is saved on).
This PC is in a LAN of 4 other PC's ( via Linksys router).
No other PC tries to access this file via the LAN,
the folder containing this file is NOT shared.

For some reason, if I load MS Access (app) first and then
use "File>Open>" and open this file, not only Access
itself, but the MDB loads in less than 4 seconds or so.

But if I double click the MDB file from Windows Explorer,
or if I use a shortcut, it takes more than 25 to 30 seconds
for a complete load!
As long as I know, MDB is associated with MS Access only.

The file is less than 600 KB.
Here is the key. If I turn the router off and double click the
file, it loads instantly. The moment I turn the router on, goes
back to about 30 seconds.

I guess explorer goes around a circle to all the LAN PC's
then returns the PC it was used and then loads the file or
something like that (my dumb guess).
I have checked every setting in TweakUI, but no luck.

What I need is help in a way to disable this explorer going
around circle and causing delay.

This is only happening to ACCESS files only, and only when
LAN is on, and only when I double click mdb or use shortcut.

I have faked my email address. Spammers burn in HELL.
Regards,
Mike

 

[ma]

I resolved this issue & will post the solution
in case someone else has similar problem.

I had disallowed ACCESS to connect to the
Internet, because I thought it prevent wasting
time. But ACCESS (or EXCEL, WORD, etc)
need from time to time download root certificate
text from a third party, and if can not update that
will repeat it everytime.

I changed disallow to allow for Access, and it
loads & runs fast enough.

Mike