Hello,
Sometimes when a user makes a layout change to a query and Access prompts the user upon closing the query if changes should be saved, it then prompts the user to save a copy of the query instead of just saving the layout changes to the original query.
I am not sure why at times Access continually prompts the user in this way, and at other times it simple saves the layout changes to the original query without prompting to save a new query.
What causes Access to behave this way at times and how can I avoid this "save a copy" prompt? Thanks
Sometimes when a user makes a layout change to a query and Access prompts the user upon closing the query if changes should be saved, it then prompts the user to save a copy of the query instead of just saving the layout changes to the original query.
I am not sure why at times Access continually prompts the user in this way, and at other times it simple saves the layout changes to the original query without prompting to save a new query.
What causes Access to behave this way at times and how can I avoid this "save a copy" prompt? Thanks