I've got a program that has multiple subs accessing a database to update
data on a form in the the db. Is it better to open and close recordsets as
needed, or is it better to open a recordset once, leave it open and access
as needed and close when the user is finished with the program. What if one
of the recordsets is a query in Access?

Thanks.

This can be a great debate subject... but here's my 2c.

Most of the answers lay in how the product will be used over a network !

I usually have the database open throughout the execution of the app.

If the recordset is being used within a 'Modal' form then I may leave the
recordset open until the modal form is closed, but only if it has a coding
benefit.  Otherwise I open and close recordset as needed.

Regards
Steve Thornton