I am seeing performance issues with an Access 2000 front end on different 

platforms. User A(WinNT 4.0 SP6) User B(Win 2000 SP2). Server Windows 2000 

Service Pack 2



When I run my application I have a procedure which runs select statements 

to insert data into a table and run checks on the data. On User A(WINNT) 

machine this process takes 20 min (this time frame is expected). On UserB

(Win2000) the process takes about 70 min.



Any ideas why this would be happening??

FYI



After speaking with a MS rep I found the answer

The version of Jet that comes packaged with SP2 for windows 2000 is known 

to cause performance problems. MS is currently reviewing this issue so 

there is no doucmentation or SP on it. They do however provide a hotfix 

which is a differnet veriosn of msjet40.dll. After I installed hotfix I 

noticed an improved performance immediatley.