zipping a database on a webpage

[Raymondo]

I wish to be able to allow a viewer to be able to download a database from
our website and have read elswhere that this can be done by adding it as a
zipped file to a page (Have seen that you cannot simply add a link to the
fpdb).

If this is done will the file be automatically updated when the database is
updated or does it have to be re-zipped each time?

Or is there an easier solution?

Jenny

 

[Thomas A. Rowe]

You would have to re-zip the file anytime it is changed.

Have you considered creating data access pages which would one or more individual (via a login)
access/view the content of the database via their browser instead of having to download the
database?

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

 

[Raymondo]

That's what i thought... I would add the login page but the user needs to be
able to use the raw access .mdb file to extract some of the fields into WORD
merge files etc.

If that's possible then it would certainly be the answer but I need guidance

 

[Thomas A. Rowe]

Via handcoded ASP, you can create a function that will generate a Excel file for downloading that
the user can then use for mail merge in either Word or Excel.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

 

[Raymondo]

Thanks, Thomas... I will have to see if I can find an ASP script to do that
as I don't think I have the hand coding skills! Thanks for your help and if
you know of any scripts I would be grateful.

 

[Thomas A. Rowe]

Do a search using the following:

Create Excel Output from Access with ASP

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
http://www.Ecom-Data.com
==============================================

 

[MikeR]

I wish to be able to allow a viewer to be able to download a database from
our website and have read elswhere that this can be done by adding it as a
zipped file to a page (Have seen that you cannot simply add a link to the
fpdb).

If this is done will the file be automatically updated when the database is
updated or does it have to be re-zipped each time?

Or is there an easier solution?

Jenny

It doesn't have to be zipped to be downloaded. What size is the .mdb, and what kind
of connection does the downloader have?
Mike