 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Macros / August 2007Avoiding Errors - Re-Post
I have a Macro that runs on a scheduler, it runs every 30 minutes and it updates the our database. The problem that I have is that if someone has that Table open, the macro errors out and Locks the database. what can I add to the macro to ignore the error and either loop until it works or just ignore the error and close. it runs every 30 minutes and for only a 10 hour period. The error is 3051, cannot open file, it is already open or you do not have permissions. *** Side note, I want to go on vacation and not have to worry about taking my Laptop to check for errors *** Thanks,  Signature-The Novice Learn Today, Teach Tomorrow Great Success is ones ability to ask for Help. Macros ... "we don' need no steenken' errors!" Macros do not have error handling (at least in the historical versions of Access - which version are you using?). If you want error handling, you'll need to look into creating VBA procedures/code modules. Regards Jeff Boyce Microsoft Office/Access MVP >I have a Macro that runs on a scheduler, it runs every 30 minutes and it > updates the our database. [quoted text clipped - 14 lines] > > Thanks, Jeff, I am running '03 Since I run a Batch file that runs the Macro... is ther somethin simular to do this with a module? This is what is in the batch file... "C:\Program Files\Microsoft Office\OFFICE11 _ \Msaccess.exe" "C:\OPSEC\OPSEC.MDB" /x "macAutoEMail" Thanks Again in Advance Signature-The Novice Learn Today, Teach Tomorrow Great Success is ones ability to ask for Help. > Macros ... "we don' need no steenken' errors!" > [quoted text clipped - 27 lines] > > > > Thanks, Can you have your batch file run a procedure instead? You could convert your Macro to a procedure and add error handling code in the procedure? Regards Jeff Boyce Microsoft Office/Access MVP > Jeff, > [quoted text clipped - 46 lines] >> > >> > Thanks, Can I convert it through Access? or are there outside tools? Signature-The Novice Learn Today, Teach Tomorrow Great Success is ones ability to ask for Help. > Can you have your batch file run a procedure instead? You could convert > your Macro to a procedure and add error handling code in the procedure? [quoted text clipped - 54 lines] > >> > > >> > Thanks, From within Access, (depending on version), you can convert a macro to a procedure at a click-of-a-button. You'll still need to do the coding to handle errors. Regards Jeff Boyce Microsoft Office/Access MVP > Can I convert it through Access? or are there outside tools? > [quoted text clipped - 62 lines] >> >> > >> >> > Thanks, |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.