imported table does not show up in list of tables

E

Ellen

Trying to import a table from another access database. No errors come up but
the table does not show up in the list of tables. Have closed out of the
database and tried again and the table still doesn't show up. Any ideas on
why it's not showing up?
 
6

'69 Camaro

Hi, Ellen.
the table does not show up in the list of tables.
Click to expand...

The name of the table will not be displayed if user-level security has been
applied and "Read design" permissions have not been assigned to your Access
User ID, or if the table is a hidden table or a system table, and the display
options for "Hidden" and "System" objects have been turned off.

To turn the "Show hidden objects" option back on, select the Tools menu ->
Options to open the Options dialog window. Select the "View" tab and make
sure that the "Hidden" check box is checked. If the table name doesn't start
with "USys" (that's a user-defined system table), then you can leave the
"Show system objects" option turned off. Select the "OK" button to save your
change.

Try to import the table again. Does the table name show up in the Import
dialog window?

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.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. Remember that the first and
best answers are often given to those who have a history of rewarding the
contributors who have taken the time to answer questions correctly.
 
Top