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.TransferD atabase acExport, "Microsoft Access", "Backup.mdb ",
acTable, "TableName" , "TableName"
Is there a way to use this and get the tables from a different
machine?
Thanks for any help.
4  2292 
ShyGuy <sh****@shytown .com> wrote in message news:<ge******* *************** **********@4ax. com>... 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.TransferD atabase acExport, "Microsoft Access", "Backup.mdb ",
acTable, "TableName" , "TableName"
Is there a way to use this and get the tables from a different
machine?
Thanks for any help.
What if you use the UNC path instead of just "Backup.mdb "? e.g.
\\SomeComputer\ SomeFolder\Back up.mdb
On 12 Oct 2004 20:50:05 -0700, pi********@hotm ail.com (Pieter Linden)
wrote: ShyGuy <sh****@shytown .com> wrote in message news:<ge******* *************** **********@4ax. com>... 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.TransferD atabase acExport, "Microsoft Access", "Backup.mdb ",
acTable, "TableName" , "TableName"
Is there a way to use this and get the tables from a different
machine?
Thanks for any help.
What if you use the UNC path instead of just "Backup.mdb "? e.g.
\\SomeComputer \SomeFolder\Bac kup.mdb
Thanks for the reply.
The Backuip.mdb is the database that is created on the drive of the
machine that is doing the backup (Drive A). I want to create this on
that drive so that if the machine that has the back end (Drive B)
crashes I will have the backup on Drive A. The problem, I think, is
getting the transferdatabas e to take the tables from the backend, on
tDrive B, and "export" them to the "backup.mdb on the Drive A.
ShyGuy <sh****@shytown .com> wrote in message news:<mi******* *************** **********@4ax. com>... On 12 Oct 2004 20:50:05 -0700, pi********@hotm ail.com (Pieter Linden)
wrote:
ShyGuy <sh****@shytown .com> wrote in message news:<ge******* *************** **********@4ax. com>... 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.TransferD atabase acExport, "Microsoft Access", "Backup.mdb ",
acTable, "TableName" , "TableName"
Is there a way to use this and get the tables from a different
machine?
Thanks for any help.
What if you use the UNC path instead of just "Backup.mdb "? e.g.
\\SomeComputer \SomeFolder\Bac kup.mdb
Thanks for the reply.
The Backuip.mdb is the database that is created on the drive of the
machine that is doing the backup (Drive A). I want to create this on
that drive so that if the machine that has the back end (Drive B)
crashes I will have the backup on Drive A. The problem, I think, is
getting the transferdatabas e to take the tables from the backend, on
tDrive B, and "export" them to the "backup.mdb on the Drive A.
Why would TransferDatabas e not work? Did you try it? If you did,
where's the code and what happened when you tried it? Have you played
with using the RENAME function from within a dummy DB? (so it can
effectively copy the database from one location to another)? Oh, and
do all this stuff on a backup. Don't want to hear "you rotten
so-and-so, you ruined my database..."
On 13 Oct 2004 21:52:18 -0700, pi********@hotm ail.com (Pieter Linden)
wrote: ShyGuy <sh****@shytown .com> wrote in message news:<mi******* *************** **********@4ax. com>... On 12 Oct 2004 20:50:05 -0700, pi********@hotm ail.com (Pieter Linden)
wrote:
>ShyGuy <sh****@shytown .com> wrote in message news:<ge******* *************** **********@4ax. com>...
>> 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.TransferD atabase acExport, "Microsoft Access", "Backup.mdb ",
>> acTable, "TableName" , "TableName"
>>
>> Is there a way to use this and get the tables from a different
>> machine?
>>
>> Thanks for any help.
>
>What if you use the UNC path instead of just "Backup.mdb "? e.g.
>
>\\SomeComputer \SomeFolder\Bac kup.mdb
Thanks for the reply.
The Backuip.mdb is the database that is created on the drive of the
machine that is doing the backup (Drive A). I want to create this on
that drive so that if the machine that has the back end (Drive B)
crashes I will have the backup on Drive A. The problem, I think, is
getting the transferdatabas e to take the tables from the backend, on
tDrive B, and "export" them to the "backup.mdb on the Drive A.
Why would TransferDatabas e not work? Did you try it? If you did,
where's the code and what happened when you tried it? Have you played
with using the RENAME function from within a dummy DB? (so it can
effectively copy the database from one location to another)? Oh, and
do all this stuff on a backup. Don't want to hear "you rotten
so-and-so, you ruined my database..."
Sorry I haven't replied sooner. I was away for a bit.
When I tried the TransferDatabas e it seeme to just transfer the link
to the remote table, not the Table itself. Not sure what you mean
with RENAME and dummy DB.. Are you saying that I have to copy the
remote (backend) DB to the local machine and then do the transfer? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: oceanhai |
last post by:
We currently have a PPTP connection set up for our developers to
access our development SQL server through a VPN tunnel. When they
need to copy tables up to the dev SQL from their local machine they
simply do a DTS copy.
However, we are now moving to a thin client solution where they will
be working on a terminal server. They will have...
|
by: PRM |
last post by:
Hi
I have an ASp.net application using C#. I need to copy a file present on the web server machine to a remote machine on the network. Although this seems to be a trivial matter I am having difficulties copying the exe
I am Trying
string Source = @"c:\temp\test.exe"
string Destination = @"Z:\test.exe"
File.Copy(Source, Destination,...
|
by: POnfri |
last post by:
Hi,
I have a problem in a peace of code were i'm doing a file copy using
File.Copy. The Source is local and the target is a remote machine.
Example: File.Copy(C:\temp\hi.txt, \\myremote\c$\temp\hi.txt, true);
This API is run from a web service that exposes it. The problem is as follows:
1) I request a page (On the web service machine)...
|
by: PRM |
last post by:
Hi
I have an ASp.net application using C#. I need to copy a file present on the web server machine to a remote machine on the network. Although this seems to be a trivial matter I am having difficulties copying the exe
I am Trying
string Source = @"c:\temp\test.exe"
string Destination = @"Z:\test.exe"
File.Copy(Source, Destination,...
|
by: Johnny |
last post by:
Hi,
I have created an ASP.NET application (let's call it FooBar) with VS.NET on
my local machine, residing in http://localhost/FooBar. Deploying it to
another folder on my machine works well with FrontPage Server Extensions,
but I don't manage to deploy the application to my web provider http root
folder.
When I run Copy Project, I get...
| | |
by: Steve Franks |
last post by:
The Copy Web tool provided with VS.NET 2005 is very convenient. However
every once in a while it seems to think the files on the remote server have
changed, which they have not. Then when I use the Copy Web Site feature of
Copy Web to just copy the entire web site over, it thinks it has to
re-upload the entire site which takes a very long...
|
by: ak1dnar |
last post by:
Hi,
I need to copy some tables from my local MsSQL(2000) database to remote MSSQL server.I think I should use DTS for this purpose.
I can Connect to remote server and I cam copy the tables to it.but the problem is getting here Once I copied it Local Table Constraints not applying to the Remote Host SQL Tables. May be I am doing wrong here.
How...
|
by: Bhavesh |
last post by:
Hi everybody,
I have problem in copying file from DatabaseServer to WebServer.Both
machines are on LAN.
Let me explain in details what i am doing & wht i want to achieve...
I am using sqlserver 2000 & asp.net 2005 for my project..
I have written one stored procedure which creates one Text file on
|
by: =?Utf-8?B?QWRyaWFuTW9ycmlz?= |
last post by:
Hello!
I'm trying to copy a file from another computer on the network that I do not
have permission with my current logon details to access.
If I open the folder using the Windows file manager with the path "\\
192.168.2.2\temp" (where temp is a shared directory on server \\192.168.2.2),
windows prompts for a User Name and password of a...
|
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...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| | |
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. ...
|
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...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
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.
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |
