Make-table queries & linked databases

[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.

I can't do it when I define the make-table query as I will
only know the location of the linked database at execution
time, so I need to define it in the code.

Does anyone know how I can do it?

Miguel