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

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


"ma" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>
>