MuratYaman.co.uk

..contributing to I.T. in London since 2002..

Month: July 2008

Deceiving MS SQL Server: UPDATE Command

First version:

It does NOT complain and it seems all right, and runs without a problem, but since I […]

Faster lookup using VBA Collections

Problem:
Reading records from the database and instead of using DLookup or querying the database all the time, to improve performance we can read them into a VBA collection object and refer to it in memory. Especially, if the data in particular tables are not changing at all or changing very rarely, we can use this facility and hold the data in memory while the application is running. Beware of the number of records in your table and the amount of memory it may consume.