Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
up vote 2 down vote accepted

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

share|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. – hourback 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!) – hourback 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.) – hourback Feb 9 '10 at 0:42
Oh wow, looks like they did the right thing by replacing the last guy :) – John T Feb 9 '10 at 1:08

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .