saving sql based query in access

[bbxrider]

i have an sql query that i build and run in a vb6 program, i want to be able to save it as make table query in the access db, so that users can run it on demand directly from access, or it can be run from the program that created it etc. been googling for an hour and not really found anything. in the distant past i have built/defined and saved tables from programs, so the same should be possible for queries?

 

[John Big Booty]

Go to the query window, Click "Create Query in design view", Close the "Show Table" window. Now go to the "View" menu and select "SQL view".

Paste your SQL statement into the query builder window. Assuming all your references and syntax are correct you will now be able to save your SQl as a query.

 

[bbxrider]

i guess i wasn't clear in the post, i want to do it from all from the program

 

[John Big Booty]

i guess i wasn't clear in the post, i want to do it from all from the program

Your right, now I'm even more confused

Can you list step by step what you want the user to be able to do.

 

[bbxrider]

yah, its not about the user, its about a vb program creating access objects, like queries. i want to create an actual query in the access db.
for example, create a query called 'getCustomers' that is a make table query that when run, creates a table called 'custs' and the sql that the query runs is 'Select * From Customers
all from vb program code, do the above and then later execute the query also from a vb program.
no user is ever involved, unless at some later point, they open up the access db, and run the existing query named 'getCustomers'

 

[John Big Booty]

OK, so this is all happening outside of the Access environment?

In that case we're operating outside my sphere of knowledge. Sorry

 

[bbxrider]

ok thanks, i know its more of a programming question, but having no luck elsewhere so thought i'd try here

 

[Access2007User]

LOL. I have understood your post#1 as John Big Booty understood it. Maybe you have to rephrase your statement.