Information générale
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Titre:
Nested Transaction in Access.
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement