ISP Hosted database

"Vic Spainhower" <[email protected]> Fri, 20 Oct 2006 16:11:12 -0700
Newsgroups gmane.comp.db.mysql.windows
Message-ID <002901c6f49d$0ad82ca0$320fa8c0@VicXP>
Hello,
 
I don't know if this is a proper question for this list but I do know there
are some very knowledgable people here who will be able to send me in the
right direction or inform me that I'm off base.
 
I've built a web site for receiving entries for shows (type of show doesn't
matter could be horse, dog, cat, car etc.) . These show entries are stored
in a MySQL database. When an entry is received the information is not only
captured in the MySQL database but it is also emailed to the Show Secretary.
The Show Secretary has an Access Database that can connect to the web site
and pick up these entries which are then copied to the Access database.
That's the 30,000 foot picture of what's going on.
 
Now here's my problem. This site is hosted at an ISP in a shared environment
because I cannot afford to have a dedicated server until this thing can get
going (if it ever does). The ISP requires that each user's IP address be
white listed and the problem being is that many (if not most) of the users
are on dial-up so the IP address is not static. So in short it doesn't work
for them.
 
I'm told that to eliminate the white listing requirement would mean turning
off the fire wall which would open a real can of worns. If this is in fact
true I cannot imagine any ISP not making white listing IP addresses
mandatory for remote connections.  On the other hand there must be a way to
secure the environment and not have to use the IP address. I like the way it
currently works because it is a seamless connection to the remote database
making it very easy to use which I really need as most of the users are not
computer savy.
 
Can anyone offer ideas on either an ISP that does not require white listing
IP addresses in a shared environment or possibly another approch to
accomplishing the same thing?
 
Thanks very much!
 
 
Vic