Forum Discussion

snowbdr's avatar
snowbdr
Copper Contributor
Aug 21, 2020

Unable to make or add tables to a query

I'm unable to make a query. When I'm in Query Design modem either for a new or existing query, the "show table" button doesn't do anything. I'm unable to get any new tables to appear available in the...
snowbdr's avatar
snowbdr
Copper Contributor
Aug 21, 2020

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.  

snowbdr's avatar
snowbdr
Copper Contributor
Aug 22, 2020

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.

Resources