Actually I'm facing a problem with recordset-objects. In more details:
Within a Workspace.BeginTrans - Workspace.CommitTrans section I want to
delete some records in a recordset of type table (named recTable1). Before I
do so I check another four recordset-objects (also of type table; named
recTable2 to recTable5) in order to ensure that my records to be deleted are
not existing in these four tables as foreign keys. This proof is also be
done within the Workspace transaction. If proof is positive (so that records
have not occured as foreign keys in any of the four tables), I always get an
error when I try to delete the records in recTable1 on grounds of err.number
3008. The mysterious thing is that according to error description delete
action has been denied because recTable4 is already opened exclusively by
another user or because it has been opened from desktop. Definitively both
reasons are not true. So I tried to close one or two of the four tables
before I delete the records in recTable1. Then the thing run properly. (What
drives me crazy as well is that it depends on which tables I close whether I
have to close one or two of them in order that error 3008 does not occur
anymore.) Of course I do not want to implement it in this "unserious" way. I
would like to close all of the recordset-objects after delete action not
All tables are part of an Access97 database. Database itself has been opened
in multi user mode. Visual Basic version is 5.0 with Service Pack 3.
No idea anymore!
Thanx in advance for any suggestions.
Yours, Reinhard Brandstoetter