In a program, in which many forms access the same access database, which is better:
a) Opening the database once globally and each form opens a different recordset (unless a global one is required)
b) Opening the database on each form, but declaring it a different variable name?

Can i have pro's and cons of both thanks?
Cheers