Does anyone know how to clear nested transactions 
Author Message
 Does anyone know how to clear nested transactions

I am trying to compact a database but keep getting the following messages. I
have successfully repaired it although am unsure whether it needed repairing
or not, I just thought it was worth a try.
I then attempt to compact it and get

The Microsoft Jet database engine could not find the object
'MSysCompactError'. Make sure the object exists and that you spell its name
and the path name correctly. (Error 3011)

Possible causes:

The specified object doesn't exist.
You misspelled the object name. Check for missing underscores ( _ ) or
other punctuation, and make sure you didn't enter leading spaces.
If you're trying to open a Btrieve table, the paths indicated in the data
definition file File.ddf may be incorrect. Be sure your data (.dat) files
are in the correct directories.

If I then try to compact it again I get

Couldn't start transaction; too many transactions already nested. (Error

You tried to nest a transaction more than five levels deep. Use the
CommitTrans or Rollback method to save or roll back the current transaction
before you begin another one.

and then immediately after clicking OK on the last error message box this
next box appears.

Operation not supported in transactions. (Error 3246)

You tried to perform an operation that isn't valid within a transaction. A
transaction can be one you create using a BeginTrans statements, or an
internal transaction created by the Microsoft Jet database engine, such as
when you delete multiple records in a single operation.

Does anyone know where I should start re the 'MSysCompactError' path?

I've had a look at help but this is all way over my head.
Regards Kevin

Sat, 30 Apr 2005 10:47:32 GMT  
 [ 1 post ] 

 Relevant Pages 

1. How to clear nested transactions

2. Did anyone know how to use Transactions in VB

3. Did anyone know how to use Transactions in VB

4. Did anyone know how to use Transactions in VB

5. AnyOne knows How It can Be Done?

6. AnyOne knows How It can Be Done?

7. Nesting SQL Server Transactions in Forms?

8. Nested transactions


10. Nested Transactions

11. Nested Transactions in Rose DAA

12. VB4-16 / DAO 2.5 / Error 3003 nested Transaction


Powered by phpBB® Forum Software