>Hi, I am new to VB and trying hardly to work on it,
>and I appreciate any help.
>
>I am opening the data file "mdb" with each form I
>create, but I don't think this is the correct way to
>do it.
>I think that I should open the file one time
>when I load the application and then deal with the
>tables around the application.
>
>Can anyone tell me how to do this, and in which form.
Which database access method are you using? DAO? ADO? RDO?
The rule is normally to open a connection, keep it in a global variable and use this variable through the entire application!
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com