I'm working on a bug in an existing program that I think has something to do with when ( and how many) transactions are being started. Does anyone know of a way to monitor how many transactions are open on a database while the program is running? The project I'm working on is using DAO against an Access 97 database.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Monitoring transactions in Access
- Thread starter Arioch
- Start date
I always open a database write or read data then close it.<br>I don't let it build up transactions.<br>When toda's PC's are mesured in Hundreds of Hertz an Billions of Bytes reading & writing data is a milli-second occurance.<br>If you are writting thousands of records an hour its time to move to SQL Server. <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.
- Status
