Hi - I just wanted to get some advice really - I use this code in the LOAD of all my forms where there is data involved...

if !dbused('gen_data')
open database gen_data shared
endif

set database to gen_data
set date british
set exclusive off
set multilocks on
set exact on


* open views

if !used('v_customers')
use v_customers shared in 0 nodata
endif

I have a couple of questions...

1. Should I be opening the database at the start of application rather than attempting it whenever I open a new form?

2. Is the order that I am doing things correct? ie. open and set database then set exclusive off?

3. Any other comments?