getting reserved error (and others) when delete record on form

[Little Elvis]

Hello.
I have two forms which have four subforms each. The subforms are on tabs
to make them fit neatly.
I have coded a delete button each form and have the delete code in the
OnDelete event method. This code asks a couple of questions to the user and
then deletes the related records...there could be hundreds of them in two
other tables.
It then writes a record to an audit table. This part is done within a
transaction.

The delete completes just fine - it appears - then I get a 3167 : Reserved
Error message. I also have got other funny messages like "could not find form
| ..."
There seems to something funny going on here. Could it be something to do
with the subforms?
Write now I am eating this error message in the form code..so my testers
don't see it until I get it sorted.

I am using. Access 2002(XP), on Windows Pro XP. The MDB is in 2000 format.

Thanks.

 

[banem2]

Hello.
  I have two forms which have four subforms each. The subforms are on tabs
to make them fit neatly.
  I have coded a delete button each form and have the delete code in the
OnDelete event method. This code asks a couple of questions to the user and
then deletes the related records...there could be hundreds of them in two
other tables.
It then writes a record to an audit table. This part is done within a
transaction.

  The delete completes just fine - it appears - then I get a 3167 : Reserved
Error message. I also have got other funny messages like "could not find form
| ..."
  There seems to something funny going on here. Could it be something todo
with the subforms?
   Write now I am eating this error message in the form code..so my testers
don't see it until I get it sorted.

I am using. Access 2002(XP), on Windows Pro XP. The MDB is in 2000 format.

Thanks.

Error 3167 points to "record is deleted" error. For the start first
make sure database isn't damaged - I recommend you to create new
database and do the File > Get External Data > Import and import all
objects including toolbars and menus. Set Start Up options (if there
are any), go to VBA screen (CTRL+G) and make sure you use same
references.

If the error appears again, let me know.

BTW You are using SQL Server as backend or it is standalone Access
database?

Regards,
Branislav Mihaljev
Microsoft Access MVP

 

[aaron_kempf]

Warning!

this Chris guy is not credible.
He does not know the basics of MS Access.

I mean 'uh Access has a bug' means MOVE TO SQL SERVER AND ADP!

-Aaron

 

[Alan]

Hello.
  I have two forms which have four subforms each. The subforms are on tabs
to make them fit neatly.
  I have coded a delete button each form and have the delete code in the
OnDelete event method. This code asks a couple of questions to the user and
then deletes the related records...there could be hundreds of them in two
other tables.
It then writes a record to an audit table. This part is done within a
transaction.

  The delete completes just fine - it appears - then I get a 3167 : Reserved
Error message. I also have got other funny messages like "could not find form
| ..."
  There seems to something funny going on here. Could it be something todo
with the subforms?
   Write now I am eating this error message in the form code..so my testers
don't see it until I get it sorted.

I am using. Access 2002(XP), on Windows Pro XP. TheMDBis in 2000 format.

Thanks.

Hi,

The mdb file is probably damaged by the code. If you don't have a
backup, you may try Advanced Access Repair at http://www.datanumen.com/aar/
This tool is rather useful in salvaging damaged Access MDB files. Hope
this helps.

Alan