Batch File Problem

  • Thread starter Thread starter Sash
  • Start date Start date
S

Sash

I posted a message on 6/5/08 "Database Crashing". I know that we're not
suppose double post, but I'm really at the end of figuring the problem out.
I tried adding msg boxes at different intervals and it always seem to blow-up
after I open the the file to write the data to. The other odd thing is that
when I add breakpoints, it runs perfectly every time. So could it be a
timing thing? If so, how can I make Access wait?

Again, sorry for the double post, but I've asked workmates and am just at
the end of knowing what direction to take. Please let me know of ANY
thoughts and if you need any addional information. You have all helped me
immensly in the past and it is greatly appreciated! I've learned a ton from
this site.

Thank you,
Sash
 
Hi Sash,
you can try to remove the on error resume next so if there's a fault in the
code the program'll stop on the offending instruction asking you what you
wanna do. Choosing debug you'll see the offending instruction.

HTH Paolo
 
Thanks Paolo. I did try removing on error resume next yesterday. The
problem is I get no error, Access just shuts down.
 
Access shut down? Do you mean it closes and stop?
Well I read your previous post where you were talking about error Oxc0000005.
Perhaps you can try to repair your Access installation or also to remove it
and then reinstall it. No others ideas, sorry.
 
Yup...closes and stops. The weirdest part is when I put breakpoints in the
code, it runs fine. I'm so frustrated!!! Thanks for your input.
 
It's actually not a batch file problem at all. It runs the batch file and
does everything up to writing to the file. This morning it ran a few times
fine, but the majority of the time crashes. The other thing that I noted on
the error log was Model: vbe6.dll the file is there, could it be corrupt?
 
Okay. I commented out all the debug.print and it runs fine. I noticed that
one of them I had "debug.print , FH" instead of "debug.print FH". Could this
have been my issue all along? Thanks to everyone for letting me rant.
 
Back
Top