The need for speed

[WhizzkidWallace]

So...I took the plunge and installed XP Pro on my workstation (then spend a whole day on patching, fixing, updating etc etc. I finally got a virgin XP Pro installation with all XP and office patches. Now to test the speed thoery....

I am running Access 2000 on an XP Pro server and workstation. Both machines are 2.6Ghz Celeron with at least 256Mb RAM (512Mb on the workstation.). I am running a VBA module which is updating 459 records using a SQL query which refers to two purpose written functions each involving opening and closing two recordsets, so in theory the function will be opening and closing 1836 recordsets. Here are the results:

1...Combined File on Local Disk.......12 seconds
2...Combined File on Server Disk.....24 seconds
3...Local Front End, Server Back end (How it should be!!!)......130 seconds !! too slow
4...Local Front End, Local Back end.....40 seconds
5...Server Front End, Server Back End.....210 seconds

Can anyone make suggestions as to why the split causes such a slow down, even when the front and back are local?

 

[John.Woody]

Have you my eariler post re sharing violations the reg fix is attached and is fully documented by microsoft if you follow the previous links