Frontpage and Access automation for updating website

[Guest]

I am working with a situation where we have data from an access database that
is kept on our local server. We would like to make some of that information
available over the internet, which is located off-site. Rather than having
to manually upload the data table every time there is change, is there a
means to provide an automatic update to the tables kept on the web server.

Our web hosting services uses Frontpage extensions and provides an alotment
for SQL data, if that information is helpful.

On a more general question, the particular subject of using database type
data on a web server is pretty new to me. Can to provide any introductory
type references where I can begin learning more about how this all works.
Thanks.

SHanagan

 

[David Berry]

Since the 2 databases aren't located on the same server then you'd have to
update the remote copy each time. If you're running SQL Server you may be
able to set up a DTS package to do the updating for you but you'd need to
look into that. You could also use SQL Server Enterprise Manager to import
the access database to the remote server. Normally you could create an ASP
page on the site to update one database from the other but in this case you
wouldn't be able to access the local MS Access Database. If your local
database was using SQL Server too then you could open up the IP Address and
then you could access it from a single ASP page on your site, open the
records you need from the local database and then insert (or update) the
ones on the remote database but this would require some good security on
your part.

 

[Guest]

David:

Thanks for your reply. In considering a "back door" type of solution here,
and this may be the wrong forum but I'll ask anyway, does Access have a means
to ftp a "snapshot" of a DB table up to the webserver. This could solve my
problem, and maintain security as well.

Steve

 

[David Berry]

Your best bet is to ask in one of the MS Access news groups.

 

[Trevor L.]

David:

Thanks for your reply. In considering a "back door" type of
solution here, and this may be the wrong forum but I'll ask anyway,
does Access have a means to ftp a "snapshot" of a DB table up to the
webserver. This could solve my problem, and maintain security as
well.

I don't see why not.

If the only thing that you are uploading is the DB, then just use any FTP
program (or Windows Explorer) to upload it.

 

[Clark]

But what I think he is trying to do is avoid having to ftp udates
constantly --

 

[Guest]

The challenge though is this:
Everytime you use FP to add/update new wab pages to the server, the current
content of the Access DB will be updated to the server also. In so doing,
overwrite any new data customers added to the online DB since the previous
update.

So the question is really how to update the server version without pushing
local DB.

ed

=========================

 

[Guest]

The challenge though is this:
Everytime you use FP to add/update a new wab page to the server, the current
content of the Access DB will be updated to the server and overwrite any new
data customers added to the online DB since the previous update.

So the question is really how to update the server version without pushing
local DB.

ed

 

[David Berry]

Mark the local database as Do Not Publish. Right-click on the mdb file,
choose properties, Workgroup tab and then check the box to exclude the file
from publishing.

 

[Guest]

Ahh.... David. Got it thanks. Rt-click on DB from within FP.
Thanks for your help.
Ed