CODEWITHSUNDEEP
ms-accessms-access-2013
Richard Winters
Richard Winters

Reputation: 125

New tables don't appear in navigation bar

I'm just starting to learn MS Access (2013). I've been following some tutorials, and so far so good, but I've run into a snag. When I create a new table and save it, the new table does not appear in the navigation bar on the left. This means that if I close the tab, I can't find the table again to reopen it.

Now, I've noticed that the problem is fixed if I close MS Access entirely, and then reopen my database... but I don't want to have to do this every time I create a new table. What is going wrong? How can I fix this?

Upvotes: 0

Views: 5592

Answers (4)

StefanoM
StefanoM

Reputation: 1

It can be used the Application.RefreshDatabaseWindow command
Example:

Dim tds As TableDefs
Dim td As TableDef

Set tds = CurrentDb.TableDefs

' new table
Set td = CurrentDb.CreateTableDef(TableName)

' add field to new table (repeat)
Set ff = td.CreateField(FieldName, FieldType, FieldLength)
td.Fields.Append ff

' add table to tabledefs collection
tds.Append td
tds.Refresh

' make the new table visible
RefreshDatabaseWindow

' close object
Set tds = Nothing

Upvotes: 0

AYOOB
AYOOB

Reputation: 1

Go to Options, Current Database, and then Navigation Options. Check Show System Options.

Upvotes: 0

Marc Guvenc
Marc Guvenc

Reputation: 1

try this. First copy the database and back it up. Then click "Compact and Repair Database". This worked for me. Sometime old database get wacky

Upvotes: 0

dwSoCal
dwSoCal

Reputation: 21

To solve this problem, use refresh (F5).

I have had the same issue in the later versions of Access (2007 and later). Although it does not appear to be in any menus/ribbons...with any object selected in the Navigation Pane, refresh (F5) will make newly-created-but-invisible tables and queries visible. Dave

Upvotes: 1

Related Questions