Loading info from Access as the application opens

Posted on 2007-08-02
Medium Priority
Last Modified: 2010-04-23
Hi all,
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.
Question by:kiranboi

Expert Comment

ID: 19615746
You can make a public recordset where you load the requered info into.
This records set can be recognized in whole the program.

You can load it in main.bas first and after that you can load the Main form for the first time.

LVL 27

Accepted Solution

planocz earned 2000 total points
ID: 19617067
One way to get around the delay is to have a splash screen first and have the data load in the background. then move on to your main app. form.

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Kraeven
Introduction Remote Share is a simple remote sharing tool, enabling you to see, add and remove remote or local shares. The application is written in VB.NET targeting the .NET framework 2.0. The source code and the compiled programs have been in…
A while ago, I was working on a Windows Forms application and I needed a special label control with reflection (glass) effect to show some titles in a stylish way. I've always enjoyed working with graphics, but it's never too clever to re-invent …
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses
Course of the Month14 days, 11 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question