Been a while since I looked at this, but doesn't a CA have beforeCursorFill and an afterCursorUpdate events? Seems you should be able to open and close tables there.

UPDATE: I have been assuming dbf's?

>I like your idea; although I have to think how it will work. I can open and close tables on access but I would have to create the BIZ object if records have to be updated. Because all my updates are done by BIZ objects. But at least, if there are no records to be updated the code can skip creating a BIZ object. But as I type this I am thinking that maybe creating BIZ on each call is not so bad (as I understand your answer "Nope"). Something still to think about.
>Thank you very much.
>
>>Nope, but another option would be to open and close the tables as part of the get data process.
>>
>>>Hi,
>>>
>>>I have a small application (that works as an add-on to a large application). The small application does the following: every 1 to 5 minutes (depending on user preference) the app (which is just one form) connects to the data and checks if some new orders were created (by another web-based application). Currently this small app has BIZ object (based on Cursor Adapter class) that does all data access and updates. The problem is that when the large app needs to do any maintenance this small app is "in the way" because it has the data tables opened. That is, when the BIZ object is created in the INIT of the form it opens some tables. I am thinking about changing design and instead of creating BIZ object in the INIT method, create it on every access to the database. Therefore, if I change the program this way, the BIZ object will be created (and then destroyed) every 1 to 5 minutes. Anybody see a problem with this approach? TIA.