> Ok, so now that we've established that there is such a thing as windows server 2011 :)...
>
> Can someone let me know if getting the FDB file onto a separate drive from the OS will address the slow performance issues?

I'm not sure if it is related to the OS, although there might be an
issue with Windows Server 2008 (AFAIK R2 has somehow fixed that)
exhausting RAM for caching.

1) Make your ADO query for reading records from your Access database
uni-directional
2) Use a parameterized INSERT INTO statement. Prepare it outside your
execution loop and change parameter inside the loop only
3) Do not commit for each record, but after e.g. 5000 records. And then,
not via commit retaining but with a "hard" commit


--
With regards,
Thomas Steinmaurer
http://www.upscene.com/