I am working on database in VB 5 and MS access. to connect to database I am using Data control.
i am using several bound controls like dbgrid,dbcombo etc. each control is having its own data control. and some data control for showing data in text boxes and etc. So a form may have 6 or 7 data controls for different putpose.

Is this right way to access database or i create recordset at runtime and get data from them.

How can we calculate memory managment and efficiency.