Make-Table Qry in backend database

  • Thread starter Thread starter Bob Bonta
  • Start date Start date
B

Bob Bonta

In the given query statement:

Select ... From ... Into tblTemp Where ...

can tblTemp be created in a backend database rather than
the frontend database in which the query is actually being
processed?

Any thoughts or recommendations would be appreciated.

RSBonta
 
JaRa's idea will work, but that will assume the mdb file is in the correct
place. I might suggest a different approach.
Create the table with the layout you need in the backend.
Link to the table in the frontend.
Instead of a make table query, delete all the records in the table, then use
an append table to load the new data.
 
Thank you - but it MUST be a make-table query. The
structure changes from one query to the next and when all
is performed in one database (the current database), I
reach the max size for Access (2GB). With the temp
backend, writing & deleting temp tables in that backend, I
have an option to compact, if necessary, but each time I
iterate through the loop I delete the database and
recreate it - thus the backend never grows to the 2GB masx.

v/r

Bob
 
Thanx Raoul! As always, your recommendation worked. I
was not aware of the IN option on the SELECT statement.

Bob ...
 
Back
Top