Trouble running Macro from a From

  • Thread starter Thread starter erin.pinksen
  • Start date Start date
E

erin.pinksen

I have recently changed over from Access 2000 to 2003 (yes we are a
little behind the times) but many of my users are still using 2000 so
I haven't converted the database.

There is a complex macro that I run from a button on a form. This
macro will run if I simply double click on it in the database, but if
I try to run it through the form it will freeze up Access. This is
also true of a couple other complex macros that I need to run.

It seems to be freezing up at a point where it selects all the records
in a very large table and deletes them.

Does anyone know why running the macro from the button would cause
Access to crash?

Thanks.
 
Erin,

I don't know what could be cauing the "freezing". But I would recommend
using a Delete Query to clear the table, and an OpenQuery action in the
macro to make it happen. So if I was you I would re-design (simplify)
the macro anyway.
 
Back
Top