Re: transfer data to remote server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Joe Fallon (jfallon1_at_nospamtwcny.rr.com)
Date: 05/22/04 

Date: Fri, 21 May 2004 23:24:38 -0400

You cannot run insert statements over the Internet to an Access mdb.
You need file access.
You can do it for MSDE (which is SQL Server.) 

-- 
Joe Fallon
Access MVP
"James" <See.My.Sig@The.Bottom.com> wrote in message
news:IZsrc.988$il.308@chiapp18.algx.net...
> is there a way i can transfer data from my local access database to a
remote
> web hosts server? i want to perform batch updates at night. this way when
> people access the database they are not wasiting my local bandwidth. the
> remote web host i have supports odbc but would that be secure to just send
> insert statments thru the internet? anyone have a more secure way of doing
> this?
>
>
> -- 
> 5khzgjf9e001@sneakemail.com
>
>
>

Relevant Pages

  • Re: Copying SQL Server 2000 data to remote database - best option?
    ... SqlServer to our public internet site hosted by our web hosting ... #1) Is DTS secure over the internet without a VPN setup or does it pass ... I need to transfer data from a set of tables in SQL Server A in Country A to ... Create a DTS package in SQL Server A in country A which will read the ...
    (microsoft.public.sqlserver.dts)
  • Re: transfer data to remote server
    ... > You cannot run insert statements over the Internet to an Access mdb. ... >> web hosts server? ... >> remote web host i have supports odbc but would that be secure to just ...
    (microsoft.public.access.externaldata)
  • Re: Using Access to access an sql database on a webserver
    ... majority of those STILL DO NOT allow a open SQL SERVER port to the ... internet using a ip + port address. ... do they care how secure it is? ...
    (comp.databases.ms-access)
  • Re: Securing SQL access via the Internet
    ... Type 'sql server security best practices' and download MS document about ... across the Internet (publishing the port via one of our public IP ... What I want to find out is whether there is a secure way to do this (such ...
    (microsoft.public.sqlserver.security)
  • Securing SQL access via the Internet
    ... We will shortly have a number of clients connecting to a new SQL server ... across the Internet. ... What I want to find out is whether there is a secure way to do this (such as ... some kind of front end SQL server that relays the commands to the actual SQL ...
    (microsoft.public.sqlserver.security)