Re: table export from local Access to import in remote Access database in VB

On Sat, 30 Sep 2006 02:40:19 +0200, "Oscar" <oku@xxxxxxxxx> wrote:

¤ What would be the best scenario to achieve the following :
¤
¤ There is one master Access database which is local : DBlocal
¤ There is one remote Access database at a web server : DBremote
¤
¤ There are a few tables within DBremote which need to be updated daily
¤ according the contents of the same table within DBlocal. Since we deal with
¤ an unique ID-field within these tables I can't just perform a query to add
¤ new records because that would cause other ID-field values since it is
¤ autonumbering. Therefore I want to delete the existing tables and import the
¤ actual tables from DBlocal daily.

Why not just create a linked table in your DBLocal to the table in DBremote?


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: table export from local Access to import in remote Access database in VB
    ... I need to 'see' the local table within DBremote. ... I don't know how to access the local DB from the web server since the local ... ¤ There is one master Access database which is local: ... There is one remote Access database at a web server: ...
    (microsoft.public.vb.database)
  • Re: How to create an empty Dbase IV database?
    ... Do you know a better way to transform a DataSet into Access database? ... I am creating table and then inserting rows ... >> ¤ Hi, ... >> You can use the Jet OLEDB/dBase ISAM driver combination and Jet SQL. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Help, Connection to Access Database
    ... ¤ I met one problem of connecting Access database in asp.net web program. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: OLE DB
    ... ¤ I would like to connect an Access database to a web site. ... Is the OLE DB provider properly mutli threaded to be able to safely connect ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Loading data into an Access Table from CSV or XML
    ... ¤ ... There is no Bulk Insert from a DataTable into Microsoft Access. ...
    (microsoft.public.dotnet.framework.adonet)
Loading