Access 97 DB just hangs

[pnad]

Hello all,

I have an access 97 DB that simply hangs every morning when running the same macro. There is a windows task scheduler job that kicks off a command file that in turn excecutes a macro. This macro in turn runs a number of macros within it and it just hangs at the same macro every morning. The logs for the task scheduler do not reveal anything. The size of the DB is about 700 MB. Is there anything really obvious that I am missing here.

Any help will be appreciated.

Thanks.

 

[rjoubert]

While it is running, you should be able to hit CTRL + Break to stop the macro. I believe it should tell you where it is in it's processing...of course, it may just tell you the name of the main macro, which won't really help you at all. If it gives you the name of one of your sub-macros, go into that macro and see what it's running...perhaps there's a query in there that is taking too long to run. If you only get the name of your main macro, try running each sub-macro one-by-one to see which one hangs.

 

[pnad]

Thanks rjoubert for your quick response.

I will try this and keep you posted.