General discussion


ms access 2007 programming with performance tips????

By sunnyjat ·
i am developing an application that manipulates an acces database, using and old ADO recordsets. the reason being that the data is realtime and has to be in the connected state. I am looking for some performance tips such as wether the connection should be kept open all the time or opened and closed whenever interacting with the database. Also anyother tips as the database stores and manipulates about 1000 record each day. hence the performance drops with every day. The application is run 24-7 adding, deleting and editing arround 1000 records each day. I want the serches to be fast. Everything in the application is done by objects. each of the table are represented with objects.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums