Solved

Error when opening database - bad system tables?

Posted on 2010-09-17
12
670 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
  • 8
  • 4
12 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) 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
 
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
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
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 how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

707 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now