In MS Access 2007, what does the asterisk indicate when it appears next to a table name in the Navigation Pane?

link|improve this question
feedback

1 Answer

up vote 1 down vote accepted

An asterisk next to the table name indicates there are unsaved changes to that table.

link|improve this answer
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. – Ali Nabavi Feb 8 '10 at 6:41
If you go to the database and save it, does the asterisk remain? – John T Feb 8 '10 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!) – Ali Nabavi Feb 8 '10 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.) – Ali Nabavi Feb 9 '10 at 0:42
1  
Oh wow, looks like they did the right thing by replacing the last guy :) – John T Feb 9 '10 at 1:08
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.