Forum Discussion
Unable to make or add tables to a query
George_Hepworth Thank you for the help. This is an old database and both the GUI and the tables were .mdb files. I just converted those to .accdb files and I'm still unable to add tables to queries although now I'm getting a lot of "Run-time error '13' Type mismatch" errors on things like this...
Set mytable = db.OpenRecordset(sql)
or
Set rs = db.OpenRecordset(sql)
So that's a separate issue I'll be chasing down. I'm not able to see the table list as you suggested trying to do. I'm able to click anywhere because it does absolutely nothing when I click "show table." The table list doesn't appear at all.
The new issue with the Run-time error is solved. I needed to change the priority level of the DAO object library to come above the ADO object library in the references. I found that here: https://support.microsoft.com/en-us/help/181542/you-receive-a-type-mismatch-error-when-you-run-the-openrecordset-metho
However, I still can't add tables to queries.
Unfortunately, without being able to inspect this mdb, it's kind of hard to determine the possible problem.
On the chance that's it is related to something in that specific file itself, I'd next create a whole new accdb and import all of the existing objects from it. See if that clean file leaves behind whatever problems are impacting your ability to work.
