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


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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