If your ISP supports Virtual Private Networks (VPN), you could access the
server database via an Access front end, over the Internet. The most
successful approach to that would require using Microsoft Terminal Services,
and that would only be available on a server running Windows. I do not know
how many ISPs make TS available, but I know it normally is run within an
organization, on the organization's own server.
You would need to discuss that with the ISP (if they are hosting websites,
some may prefer the term Internet Presence Provider, abbreviated IPP). You
would also need to determine what technology your ISP supports for web
applications -- they may or may not have the Front Page Extensions which
would be necessary to use Front Page and the Database Interaction Wizard.
It is possible to download and upload the entire database, if it is of
modest size, but there are drawbacks to such an approach -- just too many
opportunities for something to go wrong.
You may have introduced too many "qualifications" for a good or simple
solution using Access as the front end.
Larry Linson
Microsoft Access MVP
<to*@nvwisp.com> wrote in message
news:11*********************@g47g2000cwa.googlegro ups.com...
Ideally, I would like to to have just one database that can be
acccessed from two locations--the local workstation over the internet
(not a LAN), and from an internet webform hosted by an ISP. If that
doesn't work, then I would need two databases that can be synchronized
(via automatic, daily batch updates?)
Again, in the scope of this, I will be developing mailing labels using
this database; I want to develop these labels efficiently and to be
easily-maintainable (e.g., using Avery 2980 label templates in MS Word
mail merge), or something similar. I will also need to develop basic
reports based on different criteria.
Thanks!