Solved

Error when opening database - bad system tables?

Posted on 2010-09-17
12
698 Views
Last Modified: 2012-05-10
I am running into a problem I've not encountered before. I am running Access 2007 over a Vista Home Premium system, which had been working fine in the past.
When I create a new blank database (either mdb or accdb), I get an immediate error as soon as the database opens. The error message reads "in query expression 'szObject = wszTableName OR szReferenceObject = wszTableNam" (see 1st image below). When I click the OK button in the message box, the message pops again. It does this four times then finally stops.
If I close this newly created database, then reopen it, I get a different error message (see Image 2 below).
Suspecting a problem with the system tables, I tried to open them. I get the same error when I attempt to open the system tables, and cannot open the tables.
Interestingly enough, I have another accdb with only modules and system tables, which does not execute anything when the file is opened. I do not get any error when the accdb is opened, however I get the same error as above (Image 1) when I try to open any of the system tables.
I am getting a different error when I attempt to open another database that uses linked tables and is working on other machines (see 3rd image). This particular database uses an AutoExec macro, so the next message box that pops up is the one to end the macro. What is strange about this one is that if I step through the code that runs behind the AutoExec, I don't raise any errors. If I attempt to open any of the system tables, though, I get the same error as shown in Image 1.
I'm suspecting I am going to have to reinstall Access on this computer, but was wondering if anyone could explain to me what is going on here. Image 1 - Error when creating blank accdb or opening a system table Image 2 - Error when opening blank accdb after initial creation Image 3 - Error when opening database with linked tables.jpg
0
Comment
Question by:shambalad
[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
  • 8
  • 4
12 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 500 total points
ID: 33703313
wow!
And when you say 'blank', you really mean blank right?  You have not created *any* objects ?

If so:
1) Kinda sounds like your Access installation is corrupt.
2) or ... have you checked VBA>>Tools>>References ... for any missing References, although not the normal case for missing Refs ...

mx
0
 
LVL 7

Author Comment

by:shambalad
ID: 33706703
No missing references.
And yes, I mean blank. When I create the the database, the errors are the first thing I see.
Very strange.
0
 
LVL 7

Author Comment

by:shambalad
ID: 33706761
Office repair from disk failed.
I am going to do an uninstall with Revo Uninstaller Pro, then attempt a clean install.
Office-repair-error.jpg
Office-Setup.log
Office-Report-Error-Report.txt
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 7

Author Comment

by:shambalad
ID: 33706766
Actually, before I do anything else, I am going to run some scans on the system.
0
 
LVL 7

Author Comment

by:shambalad
ID: 33707812
Ran scans with ESET Smart Security, MalwareBytes Anti-Malware, Hitman Pro, and Sophos Anti-Rootkit. The scans were essentially clean (of course, Sophos always finds some hidden files, but none appeared to be relevant to the current situation).
Going to start with the re-install.
0
 
LVL 75
ID: 33708294
following ....
0
 
LVL 7

Author Comment

by:shambalad
ID: 33712116
I've reinstalled Office and that fixed it. I have no idea what exactly was happening with Access.
0
 
LVL 7

Author Comment

by:shambalad
ID: 33712142
This concept of 'Deleting' the question is still new to me. Now that I've thought more about this , it seems to me it may be better to leave this question out on the forum.
This question reports an unusual anomaly. Although there is no solution here (the question was 'what was happpening', not 'how to fix it'. Anyway, I think a record of this event might be useful if someone else reports the same thing in the future.

0
 
LVL 7

Author Closing Comment

by:shambalad
ID: 33712156
FInally, I guess the catch-all 'Corruption' is probably the best explanation.
0
 
LVL 75
ID: 33712177
"This question reports an unusual anomaly."
To say the least!  I've *never* seen that in 18 years!  I really think the 'why' is ... corruption somewhere.

So, did the reinstall fix this?

mx
0
 
LVL 7

Author Comment

by:shambalad
ID: 33712271
Yes, the reinstall fixed it, although getting to that point took a little effort..
First I tried to repair Office, which did not work. I then tried to remove the installation, and the remove failed. I re-booted and then ran an Install which completed successfully, although, all of the updates were already loaded to the software, so it was probably more of an overlay than a clean install. Anyway, the errors were still present in Access. At least this time, Office let me do a complete uninstall. After that, I was able to do a clean re-install. Without any updates applied, the errors in Access were gone. I then applied all of the Office updates, after which the errors were still gone.
This computer is about a year-old. Maybe sometime in the future when I'm feeling particularly masochistic, I will completely clear and reload the system.
0
 
LVL 75
ID: 33713773
So, corrupted installation. What are the chances :-)

mx
0

Featured Post

Technology Partners: 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

Suggested Solutions

Title # Comments Views Activity
unknown computers in my LAN 12 100
access vba 5 57
MS Access query 16 61
Combo box question 6 55
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

738 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