Hi, My software uses ADO to log data to a MS Access database every 10 seconds or so. Also, queries are run every 5 minutes to compile the data. I open a transaction for the compilation every 5 minutes because sometimes users turn off the PC in the middle of a sequence of queries and it messes stuff up if half of the queries have run. However, when they do that, I lose all of the imported data every 10 seconds that happened since the beginning of the transaction. What I really need is two different connections to the same DB. I want one to be in a transaction while the other continues to push the data to the database without a transaction. I have tried opening the database twice and keeping my references separate but it doesn't seem to work. If you could email me that would be great!

what language do you need in it? Also, just my 2 cents, but access might not be the best choice for something like this (which sounds a bit mission critical, access becomes corrupted quickly and easily)

When Access gives you concerns... and if this is a mission critical program... I suggest MySQL. I had problems with the number of records an Access db could hold for a mission critical app, had to covert it over to use MySQL. Infinite Recursion