Solved

Stable program

Posted on 2013-10-28
7
443 Views
Last Modified: 2013-10-28
Hi Experts,

Right now i have a Access DB running as a Task Scheduler. In other words, i have a form with a timer that executes (opens other Databases and runs Macros) 24/7 365 days a year.

The problem is that this Access DB, is not as stable as i was hoping for. I have made a current solution that closes the database by killing it in the Windows Task manager if it has frozen for more than 1 hour. (Don't ask for the solution it is complicated to explain)

I was then thinking of making a Desktop Application in Visual Studio to replace my Access Task Scheduler.

My question is: would a Application programmed correctly in Visual Studio be more stable than Access. I need the program to run 24/7 and if it crashes it should restart. How would i insure that and is it possible?
0
Comment
Question by:DCRAPACCESS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 39605015
You could try using the Task Scheduler of Windows.

Let it launch your Access app, start your processing from, say, the AutoExec macro, be done, and then quit Access.

/gustav
0
 

Author Comment

by:DCRAPACCESS
ID: 39605021
Hi Gustav,

I have a lot of criteria before opening a Access DB and executing  the Macros. So i would need a Program that i can trust running 24/7 and that is able to make a lot of tests before opening any database. I'm also controlling that the Access Databases don't crashes or ends i a loop and runs for more than 1 hour. So windows Task Scheduler is not an option as i see it.
0
 
LVL 50

Expert Comment

by:Gustav Brock
ID: 39605146
I see. The reliability of the running code would not change by this method, so if that is the problem, not the timer, then you will need something else to watch, as an Access app runs in one thread which cannot control itself.

That you could, I guess, solve with a .Net app with a "performer" and a "watcher" but it is a complete rewrite.

/gustav
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 70

Expert Comment

by:Éric Moreau
ID: 39605226
>> would a Application programmed correctly in Visual Studio be more stable than Access.

I am not a fan of Access but if you introduce the same problem in you VS (C# or VB), you will the same issue of stability!
0
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
ID: 39605318
A .Net app would only be more stable in the sense that it would be a true .EXE and not as sensitive to it's environment like MS Access is.  

 Outside of that, as the others have already said, you would continue to have the same problems your having now.

  I also wanted to kick in however that I have an MS Access App that runs as a task scheduler.   I wrote it because I had issues with certain Access versions/apps hanging at exit under certain OS's (there is a bug in A2000/2003 that generates a C0000005 at exit, which causes the Windows task scheduler to hang on occasion).

 I have it  running in/out of the system tray and have never had it freeze up and don't have any issues using it.

 So the bottom line is you need to look at what your executing.  Your apps need to be very robust, with error handling through out and you need to be following good practices, such as closing objects you open and setting any object variables to nothing.

  What I've found is that Access is actually an excellent tool for this type of use.  With an easy to use incrementally compiled VBA programming language, the ability to talk to other Office products with OLE automation, and being able to use and work with a large number of different datasources at the same time, make it a great "Swiss Army Knife" for getting things done quickly.

Jim.
0
 
LVL 57
ID: 39605329
BTW, here's what my task scheduler looks like.   As you can see, it's modeled after the Windows Task Scheduler.   While it's not as flexible in terms of options, it does handle all the basic scheduling tasks and then some.

It runs 24 x 7 without issue.

Jim.

Access based Task Scheduler
Task Schedule Options
0
 

Author Closing Comment

by:DCRAPACCESS
ID: 39606417
Thanks Jim. This was not what I was hoping to hear, but what i expected. I will only run Office vba code i many different databases, so i will keep using Access, and work even more on insuring all possible errors.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

739 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question