Make-table query deleted by system when executed

J

Jeannine Stark

The system displays "The existing query 'Create 7035' will
be deleted before you run the query". I created
the 'Create 7035' query as a simple inquiry query; made
sure the results were the expected results; then changed
the query type to a make-table query; put in the resulting
table name (in the existing db); went to the Access Query
menu; double-clicked on the query to run and generate the
appropriate table; the system then displays the above msg.
I do want to keep the query. What am I doing wrong? The
input table into the query is a linked table, the output
is a table within the actual Access DB.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Make table query: [Enter 1] AS Test 1
Query Returning Multiple Results 1
Problem with queries and linked SQL Tables 2
Make Table query 2
Run Make Table Query on Union Query 2
Make Table query, but remove character from field 5
Queries losing fieldnames when importing from external mdb 2
Make Table Query Popups 9

Top