query "create table"

[samp]

how can I know from VBA which Data Base is pointing a query "create
table"

 

[Allen Browne]

how can I know from VBA which Data Base is pointing a query
"create table"

I think you are asking how you can tell programmatically which queries are
action queries?

Try something like this:
CurrentDb.QueryDefs("Query1").Type

It should return the value of dbQMakeTable for your 'create table' type
query.

For other values, open the code window, and press F2 to open the Object
Browser. Search for dbQAppend etc.

 

[samp]

is not it.

I would like to know where she is creating the db table.

 

[Allen Browne]

You will need to examine the SQL property of the QueryDef, e.g.:
Debug.Print CurrentDb.QueryDefs("Query1").SQL

It will look something like this:
SELECT Table1.* INTO Table2 IN 'C:\Data\AccessOutput.mdb' FROM Table1;

Parse the string to read the database it is IN.

 

[samp]

I understand now is how to get the string starting IN

 

[samp]

it thus:

?Right("SELECT Table1.* INTO Table2 IN 'C:\Data\AccessOutput.mdb' FROM
Table1", InStr("SELECT Table1.* INTO Table2 IN 'C:\Data
\AccessOutput.mdb' FROM Table1","'")+5)