Copy table from backend?

[ShyGuy]

Is ther a way to copy a table, from the backend of a split database,
into a database on another machine from the front end?

[Smartin]

ShyGuy wrote:

Is ther a way to copy a table, from the backend of a split database,
into a database on another machine from the front end?

You could do something like

SELECT * FROM [BE_TABLE_NAME] INTO [FE_TABLE_NAME];

You will have to set up the index(es) yourself afterward.

Did you mean "... copy ... into a database on a machine different than
where my FE is"? This is still doable, assuming you have access to the
remote machine, but the syntax is a bit different.

--
Smartin

[ShyGuy]

On Wed, 13 Dec 2006 19:01:06 -0500, Smartin <sm********@yahoo.com>
wrote:

>ShyGuy wrote:

>Is ther a way to copy a table, from the backend of a split database,
into a database on another machine from the front end?

You could do something like

SELECT * FROM [BE_TABLE_NAME] INTO [FE_TABLE_NAME];

You will have to set up the index(es) yourself afterward.

Did you mean "... copy ... into a database on a machine different than
where my FE is"? This is still doable, assuming you have access to the
remote machine, but the syntax is a bit different.

Thanks for the reply. Sorry I didn't give enough info.

I have a DB that is not split and I have code that crates a DB on a
remote machine and then copies a table form the DB I'm working on into
the newly created DB. It works fine but when I split the DB the code
only copies the link. I need to copy the actual table from the back
end.

[Smartin]

ShyGuy wrote:

On Wed, 13 Dec 2006 19:01:06 -0500, Smartin <sm********@yahoo.com>
wrote:

>ShyGuy wrote:

>>Is ther a way to copy a table, from the backend of a split database,
into a database on another machine from the front end?

You could do something like

SELECT * FROM [BE_TABLE_NAME] INTO [FE_TABLE_NAME];

You will have to set up the index(es) yourself afterward.

Did you mean "... copy ... into a database on a machine different than
where my FE is"? This is still doable, assuming you have access to the
remote machine, but the syntax is a bit different.

Thanks for the reply. Sorry I didn't give enough info.

I have a DB that is not split and I have code that crates a DB on a
remote machine and then copies a table form the DB I'm working on into
the newly created DB. It works fine but when I split the DB the code
only copies the link. I need to copy the actual table from the back
end.

Then this ought to work:

SELECT * INTO [dest_table_name] IN 'path_to_dest_MDB'
FROM [source_table]

--
Smartin

[ShyGuy]

On Sat, 16 Dec 2006 19:31:44 -0500, Smartin <sm********@yahoo.com>
wrote:

>ShyGuy wrote:

>On Wed, 13 Dec 2006 19:01:06 -0500, Smartin <sm********@yahoo.com>
wrote:

>>ShyGuy wrote:
Is ther a way to copy a table, from the backend of a split database,
into a database on another machine from the front end?
You could do something like

SELECT * FROM [BE_TABLE_NAME] INTO [FE_TABLE_NAME];

You will have to set up the index(es) yourself afterward.

Did you mean "... copy ... into a database on a machine different than
where my FE is"? This is still doable, assuming you have access to the
remote machine, but the syntax is a bit different.

Thanks for the reply. Sorry I didn't give enough info.

I have a DB that is not split and I have code that crates a DB on a
remote machine and then copies a table form the DB I'm working on into
the newly created DB. It works fine but when I split the DB the code
only copies the link. I need to copy the actual table from the back
end.

Then this ought to work:

SELECT * INTO [dest_table_name] IN 'path_to_dest_MDB'
FROM [source_table]

ere do I put this code? I tried behind a button and get an expected
Case error.

I tried it in the SQL window of a query and it wouldn't let me save or
return to design view. Seems to have locked up.

[Smartin]

ShyGuy wrote:

On Sat, 16 Dec 2006 19:31:44 -0500, Smartin <sm********@yahoo.com>
wrote:

>ShyGuy wrote:

>>On Wed, 13 Dec 2006 19:01:06 -0500, Smartin <sm********@yahoo.com>
wrote:

ShyGuy wrote:
Is ther a way to copy a table, from the backend of a split database,
into a database on another machine from the front end?
You could do something like

SELECT * FROM [BE_TABLE_NAME] INTO [FE_TABLE_NAME];

You will have to set up the index(es) yourself afterward.

Did you mean "... copy ... into a database on a machine different than
where my FE is"? This is still doable, assuming you have access to the
remote machine, but the syntax is a bit different.

Thanks for the reply. Sorry I didn't give enough info.

I have a DB that is not split and I have code that crates a DB on a
remote machine and then copies a table form the DB I'm working on into
the newly created DB. It works fine but when I split the DB the code
only copies the link. I need to copy the actual table from the back
end.

Then this ought to work:

SELECT * INTO [dest_table_name] IN 'path_to_dest_MDB'
FROM [source_table]

ere do I put this code? I tried behind a button and get an expected
Case error.

I tried it in the SQL window of a query and it wouldn't let me save or
return to design view. Seems to have locked up.

That was straight SQL that works for me, it should work in the SQL query
view. Would you post what you tried?

--
Smartin

[ShyGuy]

On Mon, 18 Dec 2006 20:19:47 -0500, Smartin <sm********@yahoo.com>
wrote:

>ShyGuy wrote:

>On Sat, 16 Dec 2006 19:31:44 -0500, Smartin <sm********@yahoo.com>
wrote:

>>ShyGuy wrote:
On Wed, 13 Dec 2006 19:01:06 -0500, Smartin <sm********@yahoo.com>
wrote:

ShyGuy wrote:
>Is ther a way to copy a table, from the backend of a split database,
>into a database on another machine from the front end?
You could do something like
>
SELECT * FROM [BE_TABLE_NAME] INTO [FE_TABLE_NAME];
>
You will have to set up the index(es) yourself afterward.
>
Did you mean "... copy ... into a database on a machine different than
where my FE is"? This is still doable, assuming you have access to the
remote machine, but the syntax is a bit different.

Thanks for the reply. Sorry I didn't give enough info.

I have a DB that is not split and I have code that crates a DB on a
remote machine and then copies a table form the DB I'm working on into
the newly created DB. It works fine but when I split the DB the code
only copies the link. I need to copy the actual table from the back
end.
Then this ought to work:

SELECT * INTO [dest_table_name] IN 'path_to_dest_MDB'
FROM [source_table]

ere do I put this code? I tried behind a button and get an expected
Case error.

I tried it in the SQL window of a query and it wouldn't let me save or
return to design view. Seems to have locked up.

That was straight SQL that works for me, it should work in the SQL query
view. Would you post what you tried?

I just retried the code and for some reson, user error on previous try
;-( , it worked fine. I think I tried to use a variable in the
destination db name.

I had wanted to generate a date on the destination but I guess I can
live without that.

Thanks you so much for your help.

[Smartin]

ShyGuy wrote:

On Mon, 18 Dec 2006 20:19:47 -0500, Smartin <sm********@yahoo.com>
wrote:

>ShyGuy wrote:

>>On Sat, 16 Dec 2006 19:31:44 -0500, Smartin <sm********@yahoo.com>
wrote:

ShyGuy wrote:
On Wed, 13 Dec 2006 19:01:06 -0500, Smartin <sm********@yahoo.com>
wrote:
>
>ShyGuy wrote:
>>Is ther a way to copy a table, from the backend of a split database,
>>into a database on another machine from the front end?
>You could do something like
>>
>SELECT * FROM [BE_TABLE_NAME] INTO [FE_TABLE_NAME];
>>
>You will have to set up the index(es) yourself afterward.
>>
>Did you mean "... copy ... into a database on a machine different than
>where my FE is"? This is still doable, assuming you have access to the
>remote machine, but the syntax is a bit different.
Thanks for the reply. Sorry I didn't give enough info.
>
I have a DB that is not split and I have code that crates a DB on a
remote machine and then copies a table form the DB I'm working on into
the newly created DB. It works fine but when I split the DB the code
only copies the link. I need to copy the actual table from the back
end.
Then this ought to work:

SELECT * INTO [dest_table_name] IN 'path_to_dest_MDB'
FROM [source_table]
ere do I put this code? I tried behind a button and get an expected
Case error.

I tried it in the SQL window of a query and it wouldn't let me save or
return to design view. Seems to have locked up.

That was straight SQL that works for me, it should work in the SQL query
view. Would you post what you tried?

I just retried the code and for some reson, user error on previous try
;-( , it worked fine. I think I tried to use a variable in the
destination db name.

I had wanted to generate a date on the destination but I guess I can
live without that.

Thanks you so much for your help.

Ahh, a PEBKAC error (^: I'm sure I've never done that (^;

You can generate an additional (date) field if you desire. A couple
things I discovered:

// inserts NEW_FIELD at "left" of others
SELECT *, Date() AS NEW_FIELD INTO [dest_table_name] IN 'path_to_dest_MDB'
FROM [source_table]

// inserts NEW_FIELD at "right" of others
SELECT [source_table].*, Date() AS NEW_FIELD INTO [dest_table_name] IN
'path_to_dest_MDB'
FROM [source_table]

--
Smartin