
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
3003)
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