I am wondering where is the best place to use DBEngine.Idle dbRefreshCache in my data objects.
My objects encapsulate some DAO functionality.
E.g. Customer Object has the following methods:
Get the picture?
For a multiuser environment DAO literature quotes that you should periodically use DBEngine.Idle dbRefreshCache to suspend processing and let the DAO engine catch up.
My question is where would be the best place to use this in my objects.
I was thinking of sticking it in all the methods that change the recordset,i.e AddNew,Delete, Update and SaveChanges.
I am thinking correct or do I need certifying?
Should I just use it on all the methods including MoveFirst, MoveNext etc.
Thanks in Advance.