>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!