Unable to make or add tables to a query

%3CLINGO-SUB%20id%3D%22lingo-sub-1604629%22%20slang%3D%22en-US%22%3EUnable%20to%20make%20or%20add%20tables%20to%20a%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604629%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20unable%20to%20make%20a%20query.%20When%20I'm%20in%20Query%20Design%20modem%20either%20for%20a%20new%20or%20existing%20query%2C%20the%20%22show%20table%22%20button%20doesn't%20do%20anything.%20I'm%20unable%20to%20get%20any%20new%20tables%20to%20appear%20available%20in%20the%20query%20design.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20reviving%20an%20old%20database%20with%20a%20split%20front%2Fback.%26nbsp%3B%20Everything%20works%20fine%20and%20I%20can%20edit%20everything%20including%20queries%20except%20for%20adding%20tables%20to%20queries.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604739%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20make%20or%20add%20tables%20to%20a%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604739%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767361%22%20target%3D%22_blank%22%3E%40snowbdr%3C%2FA%3E%26nbsp%3BThat%20is%20an%20unusual%20problem%2C%20and%20one%20that%20calls%20for%20additional%20details%20in%20order%20to%20guess%20what%20might%20be%20causing%20this.%20For%20example%2C%20one%20possibility%20could%20be%20that%20this%20is%20an%20accdE%2C%20not%20an%20accdB.%20Is%20that%20that%20case%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20any%20case%2C%20new%20tables%20wouldn't%20exactly%20appear%20in%20the%20query%20design%20grid%3B%20they'd%20appear%20as%20a%20list%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Addtables.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F213817i2DEA52A8D6DE81C5%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Addtables.png%22%20alt%3D%22Addtables.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20that%20table%20list%20doesn't%20appear%20visible%2C%20maybe%20it's%20opening%20somewhere%20towards%20the%20edge%20of%20the%20screen%20in%20such%20a%20way%20as%20to%20not%20be%20apparent%20to%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20possible%20to%20verify%20this%20by%20attempting%20to%20do%20some%20editing%20in%20the%20query%20grid%20immediately%20after%20clicking%20the%20%22Add%20Tables%22%20button.%20It%20opens%20as%20a%20modal%2C%20which%20will%20prevent%20you%20from%20clicking%20on%20any%20other%20object.%20Does%20that%20happen%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20also%20possible%20to%20add%20tables%20to%20an%20existing%20or%20new%20query%20by%20dragging%20them%20from%20the%20Navigation%20Pane%20into%20the%20top%20section%20of%20the%20query%20grid%20with%20other%20tables.%20Can%20you%20do%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604826%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20make%20or%20add%20tables%20to%20a%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604826%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F126074%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3E%26nbsp%3BThank%20you%20for%20the%20help.%26nbsp%3B%20This%20is%20an%20old%20database%20and%20both%20the%20GUI%20and%20the%20tables%20were%20.mdb%20files.%26nbsp%3B%20I%20just%20converted%20those%20to%20.accdb%20files%20and%20I'm%20still%20unable%20to%20add%20tables%20to%20queries%20although%20now%20I'm%20getting%20a%20lot%20of%20%22Run-time%20error%20'13'%20Type%20mismatch%22%20errors%20on%20things%20like%20this...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESet%20mytable%20%3D%20db.OpenRecordset(sql)%3C%2FP%3E%3CP%3Eor%3C%2FP%3E%3CP%3ESet%20rs%20%3D%20db.OpenRecordset(sql)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20that's%20a%20separate%20issue%20I'll%20be%20chasing%20down.%26nbsp%3B%20I'm%20not%20able%20to%20see%20the%20table%20list%20as%20you%20suggested%20trying%20to%20do.%26nbsp%3B%20I'm%20able%20to%20click%20anywhere%20because%20it%20does%20absolutely%20nothing%20when%20I%20click%20%22show%20table.%22%26nbsp%3B%20The%20table%20list%20doesn't%20appear%20at%20all.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1604963%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20make%20or%20add%20tables%20to%20a%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1604963%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20new%20issue%20with%20the%20Run-time%20error%20is%20solved.%26nbsp%3B%20I%20needed%20to%20change%20the%20priority%20level%20of%20the%20DAO%20object%20library%20to%20come%20above%20the%20ADO%20object%20library%20in%20the%20references.%26nbsp%3B%20I%20found%20that%20here%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F181542%2Fyou-receive-a-type-mismatch-error-when-you-run-the-openrecordset-metho%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fhelp%2F181542%2Fyou-receive-a-type-mismatch-error-when-you-run-the-openrecordset-metho%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20still%20can't%20add%20tables%20to%20queries.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1605570%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20make%20or%20add%20tables%20to%20a%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1605570%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767361%22%20target%3D%22_blank%22%3E%40snowbdr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUnfortunately%2C%20without%20being%20able%20to%20inspect%20this%20mdb%2C%20it's%20kind%20of%20hard%20to%20determine%20the%20possible%20problem.%3C%2FP%3E%3CP%3EOn%20the%20chance%20that's%20it%20is%20related%20to%20something%20in%20that%20specific%20file%20itself%2C%20I'd%20next%20create%20a%20whole%20new%20accdb%20and%20import%20all%20of%20the%20existing%20objects%20from%20it.%20See%20if%20that%20clean%20file%20leaves%20behind%20whatever%20problems%20are%20impacting%20your%20ability%20to%20work.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1608682%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20make%20or%20add%20tables%20to%20a%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1608682%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767361%22%20target%3D%22_blank%22%3E%40snowbdr%3C%2FA%3E%26nbsp%3BCan%20you%20share%20you%20Office%20version%2Fbuild%2Fchannel%3F%26nbsp%3B%20You%20should%20be%20able%20to%20see%20this%20information%20by%20choosing%20File%2FAccount%2C%20and%20looking%20for%20'About%20Access'%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1651396%22%20slang%3D%22en-US%22%3ERe%3A%20Unable%20to%20make%20or%20add%20tables%20to%20a%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1651396%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F767361%22%20target%3D%22_blank%22%3E%40snowbdr%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHave%20you%20tried%20just%20dragging%20and%20dropping%20tables%20from%20the%20main%20table%20list%20to%20the%20query%20window%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22jchrisj_0-1599710740280.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F217454i777480DE06881593%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22jchrisj_0-1599710740280.png%22%20alt%3D%22jchrisj_0-1599710740280.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EChris%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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 query design.

 

I am reviving an old database with a split front/back.  Everything works fine and I can edit everything including queries except for adding tables to queries. 

6 Replies
Highlighted

@snowbdr That is an unusual problem, and one that calls for additional details in order to guess what might be causing this. For example, one possibility could be that this is an accdE, not an accdB. Is that that case? 

 

In any case, new tables wouldn't exactly appear in the query design grid; they'd appear as a list like this:

Addtables.png

 

If that table list doesn't appear visible, maybe it's opening somewhere towards the edge of the screen in such a way as to not be apparent to you.

 

It's possible to verify this by attempting to do some editing in the query grid immediately after clicking the "Add Tables" button. It opens as a modal, which will prevent you from clicking on any other object. Does that happen? 

 

It's also possible to add tables to an existing or new query by dragging them from the Navigation Pane into the top section of the query grid with other tables. Can you do that?

 

 

 

 

Highlighted

@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-o...

 

However, I still can't add tables to queries.

Highlighted

@snowbdr 

 

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.

Highlighted

@snowbdr Can you share you Office version/build/channel?  You should be able to see this information by choosing File/Account, and looking for 'About Access':

 

Highlighted

@snowbdr 

Have you tried just dragging and dropping tables from the main table list to the query window?

 

jchrisj_0-1599710740280.png

Cheers

 

Chris