I'm trying to establish a robust yet inexpensive method of updating an
online database (hopefully postgres) via a customer's database (Access).
The goal is to update the online database nightly via an ODBC connection.
My problem is that the customer's web site is on a virtual host, so I don't
rule it like I want to (probably a real good idea). My customer will dial
in
to his ISP and is assigned a dynamic IP. This seems to defeat the host
based access, since one can never predict what the IP will be.
I suppose I revert to password based access, but I can find zero
documentation on how to do this.
Has anyone done this? Can it be done?