Software

Ask something
Discussion Locked

Access make-table query

0 helpful
5 replies

by skeeter60

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

How do I keep a make-table query from deleting after it has created the table? It appears as if the query may save(not always)after running it the first time but then it is deleted after being run a second time. The query is a bit complex (for me that is) and is created from another query. It has multiple expressions in it and I don't want to have to re-create it. I need to keep the query because I have to re-create the table because I have to then save the table as a text document to be added to another mainframe application.
Thanks in advance.
skeeter60

5 replies

by dklippert

Don't give the Query the same name as the Table it's going to create. I like Leszynski/Hungarian notation.
tblSalesToDate
qrySalesToDate
frmSalesToDate
rptSalesToDate
mcrSalesToDate
basSalesToDate

by bob sellman

I assume that you save the query once you have created it, before you actually run it.

You are going to have to check your query and make sure that there are no name duplications, otherwise you might be over-writing your query or deleting it as part of the operation of the query. Since you are using other queries as your source, be sure to check all of your source queries (which should be select type queries only).

To help reduce the confusion, use more standard type naming conventions for the queries by starting the name of each query with a "q", such as qsel for a select type of query. This helps avoid confusing queries with tables.

This discussion is closed to new replies.