Thank you for your reply.

I am using ADO. Kindly, can you show me an example.

Rgrds


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