Hi,

This is about an Access application. Just upsized the backend database to SQL Server.

Redirected linked table through ODBC in the MDB and worked just fine.

But ODBC won't support nested transactions and in my code there are quite a few. I have to comment out wrk.begintrans and wrk.committrans from all outside transaction or calling functions to get my program running.

I still want to use nested transactions, or some alternatives.

Any help?

Thanks,
~Sheldon