We currently migrated from DAO to ADO and I'm having problems when using Nested Transactions with SQL Server. The recordset (cursor) appears to get closed after submitting a commit. Why does this happen? Is there a property setting in the connection string I should be aware of? My connect string is as follows:
"Provider=sqloledb;Data Source=MARYANNE;Initial Catalog=Labor32;Trusted_Connection=Yes"
The cursor type is set to adOpenKeyset
Set recsADO.ActiveConnection = UserConn
recsADO.CursorType = adOpenKeyset
This also happens when I use the update method... I cannot go back and refer to my recordset.
Any help in this area would be greatly appreciated.