By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,190 Members | 1,063 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,190 IT Pros & Developers. It's quick & easy.

Copy table from backend?

P: n/a
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?
Dec 13 '06 #1
Share this Question
Share on Google+
7 Replies


P: n/a
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
Dec 14 '06 #2

P: n/a
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.
Dec 14 '06 #3

P: n/a
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
Dec 17 '06 #4

P: n/a
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.
Dec 17 '06 #5

P: n/a
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
Dec 19 '06 #6

P: n/a
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.
Dec 21 '06 #7

P: n/a
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
Dec 23 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.