Performance issue when opening Acc97 Runtime MDB on Windows XP?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tony Ciconte - 20 Mar 2004 19:27 GMT

I have developed an Acc97 application and distribute it using the Wise
installation system and SageKey scripts. The installations are rock
solid and the product works well on all types of systems.

However, we have notice a peculiar issue when running on Windows XP
systems. Specifically, it may take up to one minute to re-attach the
data tables from the network server. The application is split between
a front-end and back-end. This only happens on XP workstations. We had
long since taken the advice posted by Tony Toews in September of 2002
to attach the first table and open a recordset using it before
attaching the rest. We have a recent report from a client who runs a
Windows XP peer-to-peer setup where both the workstations and the
server are running XP. Their connecting times seem to be a longer
still.

Since this only happens on XP systems, I can only assume it related to
XP somehow. Are there any other tips when using XP to help this
situation? Does anybody know any XP settings that might affect it? We
have already done a search of Google and KB articles. The only
appropriate hit seemed to be the one from Tony Toews referenced above.

Any and all assistance is appreciated.

Reply to this Message

david epsom dot com dot au - 21 Mar 2004 23:32 GMT

1) Always check the Anti-Virus settings
2) And check how deeply nested the Data folder is in the file system
3) And that you aren't running any extra network protocols
4) On XP, you can use a shortcut to run A97 in a Win98 compatibility mode.
5) There were a few reports that XP Home was not a good platform for Access.
6) At home, you can also try XPlite: http://www.litepc.com/xplite.html

(david)

> I have developed an Acc97 application and distribute it using the Wise
> installation system and SageKey scripts. The installations are rock
[quoted text clipped - 18 lines]
>
> Any and all assistance is appreciated.

Reply to this Message

Tony Ciconte - 26 Mar 2004 13:44 GMT

David,

Thanks for the help and insight. However, I have a couple of
clarification questions.

1) Could you please tell me what the Anti-Virus settings should or
should not be? I have advised them to put MDB and MDE files on the
exception list. Is this what you were referring to?

2) Allegedly the data folder is only 3 levels deep. Is that too much?

We had not thought about extra network protocols. Do you have an idea
of how many is too many?

Again, I want to thank you for your help.

Tony Ciconte
DSI

>1) Always check the Anti-Virus settings
>2) And check how deeply nested the Data folder is in the file system
[quoted text clipped - 27 lines]
>>
>> Any and all assistance is appreciated.

Reply to this Message

david epsom dot com dot au - 28 Mar 2004 09:39 GMT

1) Yes, just excluding MDB & MDE files from AV scanning is important.
If you want to try better, exclude LDB files, all network drives, all
temp folders, and the entire application folder.

2) It has been pointed out that the system checks the inheritable
security settings for each level of the folder structure. (On some
older versions of the network client, it did this for EVERY network
access). I would suggest just trying the file in the root directory,
just to check if it made a significant difference.

3) Occasionally you wind up in a situations where some protocol has
to time out before the data is passed on. Again, just check to see
if it makes any difference by turning everything off. This links to
my 5th point (try XPLite). On one PC I use, the peer-to-peer printer
needs to be disabled to get reasonable response out of the PC.

(david)

> David,
>
[quoted text clipped - 46 lines]
> >>
> >> Any and all assistance is appreciated.

Reply to this Message

david epsom dot com dot au - 28 Mar 2004 11:15 GMT

Oh, and make sure you aren't using compressed drives/folders!

(david)

> David,
>
[quoted text clipped - 46 lines]
> >>
> >> Any and all assistance is appreciated.

Reply to this Message