Re: Copy Records From Remote Database

Robert McCarter wrote:
Hello,

Can any of you offer a suggestion for copying records from a remote
database into a local database? I am using VB6 And Access 2003.

I am currently using 2 connections, one to the local one to the remote
database. I am opening a recordset on the remote table and then
using the second connection to do inserts into the local database as
I loop through the first recordset. This is very slow.

I would appreciate any advice you can give.

DAO might be faster than ADO for this.
However, if the machine has Access installed, I would consider automating
Access and using the TransferDatabase method. I strongly suspect that this
would be faster than both DAO and ADO.
See an Access VBA newsgroup for details.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"


.

Relevant Pages

  • Weird behaviour when trying to edit linked Access data via form
    ... a frontend mdb that contains the forms to edit the remote data. ... The frontend mdb is linked with another access table. ... I created a query that joines these data from local ... and linked table to one recordset ...
    (microsoft.public.access.forms)
  • Re: Accessing data from an MS Access database on a remote web serv
    ... when I call rs.UpdateBatch on the remote page. ... > updatebatch statement there. ... > simple update on the recordset in the calling page since it's disconnected ... > disconnected your recordset in the first place. ...
    (microsoft.public.inetserver.asp.db)
  • Re: Copy Contents of Recordset to a table
    ... remote DB is on a remote share and connection speeds aren't create. ... from the remote db directly into an Excel table on the client. ... TTBOMK this will create the worksheet in the existing Excel file, ... recordset manipulation may have been the best way; ...
    (comp.databases.ms-access)
  • RE: [PHP] security include from remote server
    ... files someplace else, but still access the local database? ... You would also need to allow the connection from the remote host in mysql. ... database server. ...
    (php.general)
  • How to do?
    ... currently we have a window application that deals only with ... the local database, now we want to our application can synchronize its data ... to a remote database, our plan is, buid another application which will be ...
    (microsoft.public.dotnet.framework.webservices)