How to see table? Is it hidden or something?

L

lanem

I have an Access db that someone else created. I can run this query, "SELECT
* FROM Users", and get the results from a Users table. I cannot find this
table anywhere! It's not under tables or any query or form, etc. It's like
this table is hidden or something. How can I find it? I should be an admin
for this db. Thanks.
 
6

'69 Camaro

Hi.

Select the Tools menu -> Options... to open the Options dialog window.
Select the "View" tab and check the "Hidden objects" check box. Select the
"OK" button to save your change. All items previously hidden using the
"Hidden" attribute will appear in the database window, but the icon for the
table or query will be slightly transparent to indicate that the object has
the "Hidden" attribute checked.

Do you see a "Users" table or query in the database window now?

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Top