is opening and closing the
ADODB.recordset and
ADODB.connection

for every action(a button click that trigger manipulation to the database) is advisable?

i mean everytime when you want to manipulate or relate to the database , everytime you gotta set up the connection and recordset again and again ..... Wouldn't that slow down the process?


(opinion)