Problem with Error 8519

[ivoef]

Hi,

I have the following problem:

In my Access 97 application I have a Form in datasheet view. Data source for the form is linked table. When I delete a record by pressing "delete" key or from a shortcut menu, I get undocumented Error 8519, but only when I am using form's Error event for trapping errors.

Even more when this error happens, I am not able to shutdown MSAccess except of using Task manager/End process command.

Any help?

Thanks

Ivo

 

[thornmastr]

It sounds as if you have a corrupted form. Assume it is only one form. Easiest cure is create a new database and open it. Import your sick form into the new pristine database. Rename the form, perhaps frmsick. Compress and repair new database. Close new database. Open your old sickly database. Delete the bad acting form. Import the form from the new database. Rename it to the correct name. Repair the database. Reopen the database; hopefully it will work now.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[scking]

And you can do the same by copying the old form and pasting it into the same database window using the menus or Ctrl+C & Ctrl+V. Of course you still need to do the same renaming. ----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------

 

[ivoef]

Hi,

thank you for your replies. The problem was in using Delete event without using BeforDelConfirm event. If I didn't set parameter Response to acDataErrContinue in BDC event, the Error event was called with error code 8519. But it happened only in ACCESS 97.

The second problem (with shutdown) was related to using application.quit method in ACC 97. When I have returned to old DoCmd.Quit everything is OK.

Ivo