remote SQL to local UPS

[Aaron Adamson]

Hello all, I am currently upsizing my access database to SQL. Normally
when I get new orders to my store I ftp a copy of the remote access database
to my local computer. This overwrites the local copy with the fresh orders.
There are 3 queries in the database that pull info from tables that my UPS
Connect Software (United Parcel Service software on installed on my local
machine) is connected to. I then open up UPS Connect, type in the order ID
and then all of the fields are populated. How will I do this when I change
from Access to SQL? Looking forward to your answers.

Aaron

 

[J. Clay]

Aaron,

I am assuming that your SQL data is not accessable from your local machine
at this time.

There are two options that I can think of off hand:

1) On the remote SQL, set up a DTS routine to update an mdb that you can ftp
to your local machine.

2) Set up the ability to create a VPN connection between the remote network
and your local machine. This would allow you to access the data directly
with out having to put it into an mdb for the UPS software to read. It will
be able to read direct from the SQL database.

I'm sure there are many other options, but these a relatively easy ones to
implement.

HTH,
J. Clay

 

[BJ Freeman]

When you create the ADP the code to connect to the UPS will still be in the
ADP.
so you can run your code from your desktop. You can create the View on the
SQL server.
thru the ADP the UPS program can access the tables.