I recently came across this 3-tier sample application at PlanetSourceCode which connected 2 Access through ADO. On going through the code I found that the application connected to the Database(MS Access) everytime a transaction(INSERT\UPDA TE\DELETE\VIEW) was carried out and disconnected after it was done. While what I have been doing till now is Connect to the DB at the beginning of the application( in the Form Load of the MDI) and then keep it connected throughout until the application ends.

So what is the usual\preferred method ? Any special circumstances when option1 is chosen over option 2 ?