Make-table queries & linked databases

  • Thread starter Thread starter Miguel Velez
  • Start date Start date
M

Miguel Velez

I've created a make-table query and when I run it it
creates the table in the Ms Access file where the
application is located. But I've split my application and
have a back-end file with the database; this is where I
want the table to be created.

Does anyone know how I can do it?

Miguel
 
When you change from the default Select Query to Make-
Table Query in the QBE (Query Grid), you have the option
to specify whether you want to make the Table in the
CurrentDB or another DB. I your case select "Another DB"
and specify the Back-End database.

HTH
Van T. Dinh
MVP (Access)
 
Van,

I know about that but what I should had said is that at
coding time I don't know the location of the linked
database, so I need to define the location at execution
time, i.e. from the code.

Miguel
 
If you meant all of your linked Tables come from ONE Back-End MDB (I have
applications that used 3 or 4 Back-Ends) and you want to put the new Table
in the same Back-End but you want to do it dynamically then you can look at
the Connect Property of one of the linked Table to get the path name of the
Back-End.

For example:

?CurrentDb.TableDefs("tblAccessAndJetErrors").Connect
;DATABASE=I:\MyAccess97\AccessProgTips\AccessProgTips_be.mdb

"I:\MyAccess97\AccessProgTips\AccessProgTips_be.mdb" is the path-name to the
Back-End database in this case.
 
Back
Top