Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

up vote 1 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
2  
Oh wow, looks like they did the right thing by replacing the last guy :) –  John T Feb 9 '10 at 1:08

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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