Dear Experts

I have a Database, Data1, containing three Tables
What is the best way to open Database, Data1, with Form?

In this regard I use folloiwng different methods.

1- On the LOAD event of Form I write following codes

close all
close database
open database d:\abc\data1.dbc execlusive
use table1 in 0
use table2 in 0
use table3 in 0

2- On the LOAD event of Form I write following codes

close database
use table1 in 0
use table2 in 0
use table3 in 0

3- On the LOAD event I write nothing and put all tables in DE.

Please advise me which METHOD is the best or suggest another.


Thanks