Prompt to save changes but no changes were made

terpsfan101

New member
Local time
Today, 16:56
Joined
Feb 10, 2007
Messages
1
I was editing one of my tables in datasheet view and when I closed the table, Access asked me if I wanted to save changes. But I didn't make any changes to the design of the table or the filters I had set up. I just edited the data within datasheet view. The reason this is bothering me is that I am afraid I accidentally changed something. The only explanation I have for why it asked me if I wanted to save changes, is that I used the "undo" command to cancel a typo that I made while editing in datasheet view. When I hit "undo", it fixed the typo, and scaled back up to the first record of the datasheet. At first I thought using the "undo" command might have been the culprit, but when I re-opened the table and used the "undo" command again, it undid the change, but it didn't scale back up to the first record of the datasheet, like it did the first time I used the command. Anyway, I am staying away from the undo command from now on. It's about worthless in Access anyway, because it only undoes your last action. Have any other Access users been asked to save changes when they know they haven't made any changes to the design of the table?
 
You'll get this prompt if you resize columns, change the sort order and things like that. For the most part click "no", and don't worry about your data. Changes there are saved automatically without prompts.
 
lagbolt said:
You'll get this prompt if you resize columns, change the sort order and things like that. For the most part click "no", and don't worry about your data. Changes there are saved automatically without prompts.

I had made a set of querys for a particular form and used that method to change each datasheet view to be the same. When it asked if I wanted to save the changes, of course I replied Yes :)
 

Users who are viewing this thread

Back
Top Bottom