[AccessD] Re: Make-table query points to c:\documents and settings?!

Sander,

What you have to do is open the other database in code.
Then, you can execute the SQL statement to build the
tables you are wanting.  ADO would work fine for this.
The path would be required to open the DB, but not to
create the tables.  All of this has to be done in code
and it has to be done in pure SQL as 2 different SQL
statements.  First to create the table, second to append
the data.  So you actually have to open 2 database objects,
current and remote.  If you need help with the code, let
me know and I will post it to the list.

Robert

At 12:03 PM 1/27/2004 -0600, you wrote:
>Date: Mon, 26 Jan 2004 10:44:38 -0800 (PST)
>From: Sad Der <accessd666 at yahoo.com>
>Subject: Re: [AccessD] Make-table query points to c:\documents and
>         settings?!
>To: Access Developers discussion and problem solving
>         <accessd at databaseadvisors.com>
>Message-ID: <20040126184438.97312.qmail at web60205.mail.yahoo.com>
>Content-Type: text/plain; charset=us-ascii
>
>I build it in SQL view. There's no path in there
>either... :-(
>
>Sander