L
LarsM
I once had a macro, where I first used a query to create a temporary table,
then made use of this temprary table in some append queries to add records to
some permanent tables and at last used a delete query to delete the temporary
table again. I understand very well, that the temporary table has to exist,
when I design the append queries, where I make use of the temporary table. I
also understand, that when I later open one of these append queries again in
design mode, the query can not be shown correctly, if the temporary table
does not exist at that time. The version of the query showed on the screen
in that situation can of course not be identical to, what I have previously
designed. However I don't understand, why Access automatically saves a new
version of the query. In another situation where I have (manually) made some
redesign of a query, I normally have the possibility to close the query
without saving it, and then the query returns to it's previous design. When
Access has changed the design and saved it automatically, I don't have this
possibility.
When Access has saved a new version of the query, I first have to create the
temporary table (manually or automatically), then open the append query in
design mode and manually restore the previous design. Of course it is my
fault, that I ever opened the query in design mode, whitout creating the
temporary table first, but anyway...
Now I have redesigned the macro, so I don't use temporary tables at all.
Therefore this is not a problem for me any longer. I am just curious, if
anybody knows, why Access has to save the design of the query automatically.
then made use of this temprary table in some append queries to add records to
some permanent tables and at last used a delete query to delete the temporary
table again. I understand very well, that the temporary table has to exist,
when I design the append queries, where I make use of the temporary table. I
also understand, that when I later open one of these append queries again in
design mode, the query can not be shown correctly, if the temporary table
does not exist at that time. The version of the query showed on the screen
in that situation can of course not be identical to, what I have previously
designed. However I don't understand, why Access automatically saves a new
version of the query. In another situation where I have (manually) made some
redesign of a query, I normally have the possibility to close the query
without saving it, and then the query returns to it's previous design. When
Access has changed the design and saved it automatically, I don't have this
possibility.
When Access has saved a new version of the query, I first have to create the
temporary table (manually or automatically), then open the append query in
design mode and manually restore the previous design. Of course it is my
fault, that I ever opened the query in design mode, whitout creating the
temporary table first, but anyway...
Now I have redesigned the macro, so I don't use temporary tables at all.
Therefore this is not a problem for me any longer. I am just curious, if
anybody knows, why Access has to save the design of the query automatically.