Hi,

I have a VB6.0 application accessing MS Access 97 via Microsoft Jet
OLEDB 4.0.

Everything works fine from a computer running Windows XP with an Intel
processor with 256 mg of memory but it comes to a crawl from a
computer running Windows 98 Second Edition with an AMD processor and
the same amount of memory....

Do I need to replace the CPU or the operating system?

Thank you.

Roger Bournival
bournivr (AT) hiwaay (DOT) net

On 01 Jul 2003 14:28:10 GMT in comp.databases.ms-access, Roger
Bournival <bournivr (AT) hiwaay (DOT) net> wrote:

It looks like a level playing field as far as server/network goes so
we can discount that and the 2GHz Celery vs 1.4GHz Athlon is certainly
no hare vs tortoise match. Barring any memory/disk problems on the AMD
machine I think we can rule out hardware as the culprit (if there were
any problems in that area I'd expect more problems than a slow
database application).

AFAICS this leaves only the OS or the setup of OLEDB, it may be an
idea to check the versions of MDAC
(http://support.microsoft.com/default...en-us%3B301202)
and see if it's a level playing field here, this may also show up any
problems in the setup of MDAC on any particular machine.

Otherwise I would look to the OS, not that 98 itself should slow it
down in any way (in fact I'd expect it to work better accessing
another 98 machine than the XP machine) but there may some problems in
the setup of 98 on that machine.

--
If you try to fail, and succeed, which have you done?

(replace sithlord with trevor for email)