In MS Access 2007, what does the asterisk indicate when it appears next to a table name in the Navigation Pane?
1 Answer
An asterisk next to the table name indicates there are unsaved changes to that table.
-
I exit Access completely, re-open the database, and the asterisks remain. Under which circumstances can you think of would the asterisks persist following a restart? It is a local database.– hourbackFeb 8, 2010 at 6:41
-
1If you go to the database and save it, does the asterisk remain?– user1931Feb 8, 2010 at 12:09
-
Affirmative. I click on the Office Button and the Save item is inactive. I press Ctrl + S and nothing changes. (Thanks for following up!)– hourbackFeb 8, 2010 at 22:39
-
Oh . . . my . . . god. . . . Well, turns out that the table's name -- ITS NAME -- CONTAINS AN ASTERISK. . . . Thanks anyway for your time, John. (Suffice it to say that I did not create this database and was hired to migrate data out of it.)– hourbackFeb 9, 2010 at 0:42
-
3Oh wow, looks like they did the right thing by replacing the last guy :)– user1931Feb 9, 2010 at 1:08