In addition to the previous post; the way you open a recordset has an affect on performance. If you open as readonly it will be faster, if you open as forward only, it will be faster....if your SQL statement selects exactly what you want, it will be faster, In other words if you want customers whose id is 110, a "SELECT * FROM Customer WHERE Id = 110", is going to be much faster than selecting all records and then filtering and sorting.



Jim Hewitt
Software Developer
Liberty Tax Service
www.LibertyTax.com