Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access Database Serious Error

Posted on 2014-01-28
15
Medium Priority
?
1,215 Views
Last Modified: 2014-10-05
I have designed a system of Scheduled Tasks that do numerous database updates and exporting of reports to HTML: repeating the process of logging in, completing the tasks and then logging out of Windows Server 2008 R2 every 15 minutes. Occasionally, the system fails since Microsoft Access 2010 creates a dialog box announcing that the target database created a serious error the last time it was opened and asking the user if it should be opened. Since there is no human present to reply it just waits.

Using Google Search, I've learned that there is a Disabled Items list that the target database must be removed from. How can this be done via Access' Visual Basic commands (I typically use Open Event code) or via some other command?
0
Comment
Question by:slamond
[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
15 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 39816474
Is it VBA code running in Access or is it VB.NET code?
0
 

Author Comment

by:slamond
ID: 39816650
Sorry, I need to correct the tags if possible. It's VBA.
0
 
LVL 20

Expert Comment

by:GrahamMandeno
ID: 39816780
Hi slamond

I think you'll find the disabled items list in the registry at this key:

HKCU\Software\Microsoft\Office\14.0\Access\Resiliency\DisabledItems

One solution would be to have the task manager execute a batch file instead of starting Access directly.  The batch file could run a VBscript file which checks the registry for the disabled item entry and deletes it if it is found.  Then the batch file can open the database without a problem.

Best wishes,
Graham Mandeno [Access MVP 1996-2014]
0
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

 

Author Comment

by:slamond
ID: 39835778
To GrahamMaddeno, if you or anyone else can provide the code for what you suggest it would be appreciated. My vbscript skills are limited to IF THEN ELSE.
S.
0
 

Author Comment

by:slamond
ID: 39851206
What would be the exact syntax for that code?
0
 
LVL 19

Expert Comment

by:regmigrant
ID: 39879265
here's a script to delete registry keys - you need to modify it to suit your situation and use with caution!

Dim WSHShell
On Error Resume Next
Set WSHShell = WScript.CreateObject("WScript.Shell")
WSHShell.RegDelete "HKCU\Software\Microsoft\Office\14.0\Access\Resiliency\DisabledItems"    ------ <<< make this specific for you cirsumtances!!!!
set WSHShell = nothing
0
 
LVL 15

Expert Comment

by:JimFive
ID: 39882833
You may want to find out what error Access is reporting before you hide the fact that an error happened.
0
 

Author Comment

by:slamond
ID: 39883130
For the benefit of any reader that is reviewing this incident from an historical perspective, while waiting for expert advice I had the idea to strategically space the Scheduled Tasks to minimize the chances of conflicting data access. Since taking that action the error has occurred only once. The only downside now is that it will be more difficult for me to follow JimFive's suggestion of isolating the error.

I will keep this question open until I can possibly find an event ID that points to a more specific cause of the error.
0
 
LVL 15

Expert Comment

by:JimFive
ID: 39883436
slamond,
Based on the above comment, can you make sure that the Database Option "Compact on Close" is NOT checked.
0
 

Author Comment

by:slamond
ID: 39886442
That option is not selected.
0
 

Accepted Solution

by:
slamond earned 0 total points
ID: 40353194
I will close this with the final solution being that I spaced my tasks strategically to avoid conflicts, adding tasks to use the Taskkill command to close any open database before executing each task and adding a task to run the Compact command every hour (to mitigate any potential errors related to corruption in the database). After implementing these additions, the task have run without incident for weeks at a time. The isolated failures that remain seem to be cause by tasks running longer than expected and subsequently getting terminated by the Taskkill command.
0
 

Author Closing Comment

by:slamond
ID: 40361904
It's working at about 95%.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

715 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