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? 7 2719
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
On Wed, 13 Dec 2006 19:01:06 -0500, Smartin <sm********@yah oo.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.
ShyGuy wrote:
On Wed, 13 Dec 2006 19:01:06 -0500, Smartin <sm********@yah oo.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_M DB'
FROM [source_table]
--
Smartin
On Sat, 16 Dec 2006 19:31:44 -0500, Smartin <sm********@yah oo.com>
wrote:
>ShyGuy wrote:
>On Wed, 13 Dec 2006 19:01:06 -0500, Smartin <sm********@yah oo.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_M DB' 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.
ShyGuy wrote:
On Sat, 16 Dec 2006 19:31:44 -0500, Smartin <sm********@yah oo.com>
wrote:
>ShyGuy wrote:
>>On Wed, 13 Dec 2006 19:01:06 -0500, Smartin <sm********@yah oo.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_M DB' 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
On Mon, 18 Dec 2006 20:19:47 -0500, Smartin <sm********@yah oo.com>
wrote:
>ShyGuy wrote:
>On Sat, 16 Dec 2006 19:31:44 -0500, Smartin <sm********@yah oo.com> wrote:
>>ShyGuy wrote: On Wed, 13 Dec 2006 19:01:06 -0500, Smartin <sm********@yah oo.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_M DB' 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.
ShyGuy wrote:
On Mon, 18 Dec 2006 20:19:47 -0500, Smartin <sm********@yah oo.com>
wrote:
>ShyGuy wrote:
>>On Sat, 16 Dec 2006 19:31:44 -0500, Smartin <sm********@yah oo.com> wrote:
ShyGuy wrote: On Wed, 13 Dec 2006 19:01:06 -0500, Smartin <sm********@yah oo.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_M DB' 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_M DB'
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_M DB'
FROM [source_table]
--
Smartin This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Juris Krumins |
last post by:
Couple a weeks ago (19.08.03 Subject: Temporaty tables) I've posted message
with question about errors I'm getting while using create temporaty table
command.
So I'm start digging in src code as Tom Lane did and found about 4 places
where such kind pf errors could happend
PostgreSQL 7.3.3
src/backend/catalog/dependency.c : 1621
src/backend/catalog/heap.c : 1663
|
by: Dr NoName |
last post by:
Help!
I have a table that multiple processes must be able to
write to concurrently. However, it for some reason
gets locked in exclusive mode. I narrowed it down to
one SQL statement + some weirdness with foreign keys.
To debug this, I opened two psql sessions and typed in
the sql statements manually. Here is the situation:
CREATE TABLE take2
|
by: MAB71 |
last post by:
There should be a way to copy an access database ( .mdb file ) without
closing connections to it. Unfortunately the FileCopy statement in VB gives
an error if users are connected to the db. But I can copy the file using
windows explorer so there must be a way. WinAPI function or something?
I'm using VB6 and Access 2000
|
by: Jon Ole Hedne |
last post by:
I have worked on this problem some hours now (read many-many...), and I
can't solve it:
In vba-code I create a table with Connection.Execute, and add some data to
it. This table is saved in the backend-database. After generating this
table, I want to open a report based on a query with data from this
temporary table. In the report's OnOpen event I set the report's record
source to the query pointing to the temporary table.
If I run...
|
by: ShyGuy |
last post by:
I have a routine that creates a new database and then copies a couple
of tables to the new database as backups. It works fine but I want to
split the database and run this routine from a machine that does not
have the actual tables on it. I am using the following
DoCmd.TransferDatabase acExport, "Microsoft Access", "Backup.mdb",
acTable, "TableName", "TableName"
Is there a way to use this and get the tables from a different
machine?
| |
by: Knepper, Michelle |
last post by:
Hi out there,
I'm a first-time user of the "Copy ... From..." command, and I'm trying
to load a table from a text flat file.
http://www.postgresql.org/docs/7.4/static/sql-copy.html
I don't know if I'm using the command correctly.
Question: I run this command as a superuser, and the "copy from"
command is run like a SQL command on the command line, correct?
|
by: Mark |
last post by:
I have been developing a new application (FE on local drive) which is
attached to tables in a BE on a server. For testing purposes I had a copy
of the BE in the same folder as the live BE and the application and forms
loaded quickly. The application is now ready to go live and using the
linked table manager I have tried relinking the tables to the live BE. The
tables (around 50) relink but it takes a while through the linked table...
|
by: rdemyan via AccessMonster.com |
last post by:
I have a situation where I need to create a copy of the back-end for a person
who goes on the road (Remote Back-End). It needs to be as current as
possible, so this will generally mean that others are accessing the main back-
end at the time we need to create the copy.
In reading through some posts, VB FileCopy won't work (which I've tested). I
also tested fso.CopyFile (file scripting) and that seems to always be able to
create a copy...
|
by: Jim Devenish |
last post by:
I wish to copy a table on a SQL Server backend to a table on an Access
(.mdb) front end in the simplest way.
I have the following to get the recordset but am seeking something
easier.
Dim theConnectionString
theConnectionString = "Driver=SQL Server;
Server=Server;Database=myData;Trusted_Connection=Yes"
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |