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.