table does not show

[Mark J Kubicki]

I'm designing a query and I need fields from a table that does not show
(???) in the list of tables to add...

the table is in a linked database, with a relationship to other tables in
that same database;
those 'other' tables in the linked database do show in the list;
there is data in the table and the table it is related to

how do I / why isn't it showing??

thanks in advance,
mark

 

[Jeff Boyce]

Mark

Is the linked table marked as "hidden" in either the back-end or your
front-end?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Mark J Kubicki]

....not that I'm aware.... how would I check, is this a property?
---mark

 

[Jeff Boyce]

Mark

In addition to checking Access HELP for "hidden" (not always a great source,
but a source <g>), open the db to the database window. Click on menu item
"Windows" and "Unhide" (it will be disabled if none are hidden).

Oh, did I mention, you need to be in the Tables "tab" to look for hidden
tables.

Now do the same thing in the back-end...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Dirk Goldgar]

I'm designing a query and I need fields from a table that does not
show (???) in the list of tables to add...

the table is in a linked database, with a relationship to other
tables in that same database;
those 'other' tables in the linked database do show in the list;
there is data in the table and the table it is related to

how do I / why isn't it showing??

In addition to what Jeff has suggested, I have to ask whether the table
in question is linked in *this* database. When the tables from the
other database were linked, was this table left out? If that's so, your
easiest solution is to use the File -> Get External Data -> Link
Tables... menu item to link the additional table.