Loading info from Access as the application opens
Posted on 2007-08-02
In my app I have a LinkLabel that, when clicked, opens a lookup form which pulls a series of records from an Access tbale and adds them to a listview on the lookup form.
The first time I open this form it takes a little while to load because there are so many records in the access table but every time I open it after that it loads instantly.
I need to be able to load the information into memory when the application starts so that the lookup form opens instantly even when first clicked on.
I have tried opening the lookup form with its visibility turned off as my app loads and then auto closing it once the data has been loaded but that didnt make a difference. Can someone suggest a way I can achieve this.