Newby question - database asp

P

Paul C

This is always a problem web designers create a web in frontpage with an
access database, hand it over to the client and the first thing the client
askes is "how do I backup the database"
I do it in frontpage but it is not without its perils.I created another
local web with just the database folder and then I open the remote site and
right click the database on the remote site and publish it to the local new
we. There are some things that can go wrong . first you havr to make sure
the publish from the remote to local radio button at the bottom right of the
frontpage screen is selected or the local will overwrite the remote instead
of the other way round. A simple stand alone download program from the
remote to the local where all the download criteria (username and password
and file destinations) can be set by the web designer before you give it to
the client would be usefull I have come accross such programs for SQL
databases but not access.
 
W

Wayne-I-M

I have almost got it working - will post a step by step once it's done to the
FP & access forums
 
S

Stefan B Rusynko

To download (backup) a DB from a FP SE Web site
- just open the online site in FP, select the mdb file and from the menu use File Export and select a location on your PC

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| This is always a problem web designers create a web in frontpage with an
| access database, hand it over to the client and the first thing the client
| askes is "how do I backup the database"
| I do it in frontpage but it is not without its perils.I created another
| local web with just the database folder and then I open the remote site and
| right click the database on the remote site and publish it to the local new
| we. There are some things that can go wrong . first you havr to make sure
| the publish from the remote to local radio button at the bottom right of the
| frontpage screen is selected or the local will overwrite the remote instead
| of the other way round. A simple stand alone download program from the
| remote to the local where all the download criteria (username and password
| and file destinations) can be set by the web designer before you give it to
| the client would be usefull I have come accross such programs for SQL
| databases but not access.
|
| | > Hi Paul
| >
| > I'm not sure about the "backup" approach. If I could back it up it would
| > be
| > on a drive and then I would not have this problem.
| >
| > I normally write access DB's so once I can get the results of an online
| > form
| > on a to drive there will be no problems - I have already written some code
| > to
| > import the data - query it (so that you are not over writting other
| > data) -
| > change the format (as some people don't TYPE In tHE correct case) - print
| > automatic reciepts / confirmation - append it to various tables - etc etc
| > etc.
| >
| > All I need to do is get the data - ha ha ha someone in my office told me
| > it
| > could not be done with frontpage as it was for "people who know nothing
| > about
| > web design". Hmmmmm - so you see I "have to do this".
| >
| > If (when) I work it out I will post a step by step
| >
| > BUT - still no closer to getting the data "without" opening FP and logging
| > in - at home know so will look at it again in the morning
| >
| > Thanks for your input
| >
| > --
| > Wayne
| > Manchester, England.
| >
| >
| >
| > "Paul C" wrote:
| >
| >> HI Have a lok at these, I have never used them.
| >>
| >> http://www.goodsync.com/land/land.php?affid=googs&frm=frame10
| >>
| >> http://free-backup.info/
| >>
| >> let us know how you get on
| >> Paul M
| >>
| >>
| >> | >> > OK I have relooked at the problem (with "lots" of googleing). As I
| >> > have
| >> > set
| >> > it up will not work.
| >> >
| >> > I know that you can save form results to a txt or csv file But the
| >> > same
| >> > question (almost) applies.
| >> >
| >> > Can you export or somehow have the data available onto a drive
| >> > "without"
| >> > going into frontpage -> logging in via user name and password ->
| >> > syncroing
| >> > the datebase (web to local)
| >> >
| >> > I'm still loking for a method of getting form results on a drive
| >> >
| >> > Any hints / tips
| >> >
| >> > Many thanks
| >> > --
| >> > Wayne
| >> > Manchester, England.
| >> >
| >> >
| >> >
| >> > "Thomas A. Rowe" wrote:
| >> >
| >> >> The problem is that the web is not local (unless you are self-hosting
| >> >> (which is not recommend) ,and
| >> >> you are really not using Access (the app) on the web, just it's
| >> >> database.
| >> >>
| >> >> --
| >> >> ==============================================
| >> >> Thomas A. Rowe
| >> >> Microsoft MVP - FrontPage
| >> >>
| >> >> http://www.Ecom-Data.com
| >> >> ==============================================
| >> >>
| >> >>
| >> >> | >> >> > Many thanks for your input Thomas.
| >> >> >
| >> >> > I would have thought that this was exactly what ms office was only
| >> >> > about.
| >> >> > Integrated systems - access, word, outlook, excel, FP, etc. It
| >> >> > seems
| >> >> > that
| >> >> > (from an access form ) I can call all other parts of office other
| >> >> > than
| >> >> > FP.
| >> >> > Takes a little codeing but not too difficult. I know FP uses a
| >> >> > different set
| >> >> > than the others but still .... all it would take would be to be able
| >> >> > to
| >> >> > get a
| >> >> > database from the web on to a drive and it would all work.
| >> >> >
| >> >> > I will get it to work :) (somehow)
| >> >> >
| >> >> > Many thanks again
| >> >> >
| >> >> > --
| >> >> > Wayne
| >> >> > Manchester, England.
| >> >> >
| >> >> >
| >> >> >
| >> >> > "Thomas A. Rowe" wrote:
| >> >> >
| >> >> >> Use a 3rd Party FTP application or you might be able to use Windows
| >> >> >> Scripting to automate the
| >> >> >> download process and overwrite you local version of the database.
| >> >> >>
| >> >> >> --
| >> >> >> ==============================================
| >> >> >> Thomas A. Rowe
| >> >> >> Microsoft MVP - FrontPage
| >> >> >>
| >> >> >> http://www.Ecom-Data.com
| >> >> >> ==============================================
| >> >> >>
| >> >> >>
| >> >> >> | >> >> >> > How would this be done. I can call the database if it is on a
| >> >> >> > drive
| >> >> >> > and over
| >> >> >> > write it with updates without changeing the name so that would
| >> >> >> > work.
| >> >> >> >
| >> >> >> > Any hints and or a web page that gives instructions
| >> >> >> >
| >> >> >> > Many thanks
| >> >> >> >
| >> >> >> > --
| >> >> >> > Wayne
| >> >> >> > Manchester, England.
| >> >> >> >
| >> >> >> >
| >> >> >> >
| >> >> >> > "Thomas A. Rowe" wrote:
| >> >> >> >
| >> >> >> >> Your other option is to use FTP to download the database to your
| >> >> >> >> PC.
| >> >> >> >>
| >> >> >> >> --
| >> >> >> >> ==============================================
| >> >> >> >> Thomas A. Rowe
| >> >> >> >> Microsoft MVP - FrontPage
| >> >> >> >>
| >> >> >> >> http://www.Ecom-Data.com
| >> >> >> >> ==============================================
| >> >> >> >>
| >> >> >> >>
| >> >> >> >> | >> >> >> >> > Hi
| >> >> >> >> >
| >> >> >> >> > Thanks for getting back to me.
| >> >> >> >> >
| >> >> >> >> > I have written a little "stuff" to import the form's data into
| >> >> >> >> > my
| >> >> >> >> > main
| >> >> >> >> > access database. I'm a bit confused by this database that is
| >> >> >> >> > on
| >> >> >> >> > the website.
| >> >> >> >> > The information "is" there (as when I copy it to the hard
| >> >> >> >> > drvie
| >> >> >> >> > it opens
| >> >> >> >> > fine and I can use the data).
| >> >> >> >> >
| >> >> >> >> > But I thought (maybe am wrong) that you should not need to go
| >> >> >> >> > into FrontPage
| >> >> >> >> > and open the DB. Is there not some way to have the data
| >> >> >> >> > passed
| >> >> >> >> > directly to a
| >> >> >> >> > database that can be accessed without opening FP.
| >> >> >> >> >
| >> >> >> >> > --
| >> >> >> >> > Wayne
| >> >> >> >> > Manchester, England.
| >> >> >> >> >
| >> >> >> >> >
| >> >> >> >> >
| >> >> >> >> > "Ronx" wrote:
| >> >> >> >> >
| >> >> >> >> >> Use FrontPage to:
| >> >> >> >> >> 1) Open the site on the server.
| >> >> >> >> >> 2) File->Export the database to your desktop. This copies
| >> >> >> >> >> the
| >> >> >> >> >> database
| >> >> >> >> >> on the website to your desktop.
| >> >> >> >> >>
| >> >> >> >> >> --
| >> >> >> >> >> Ron Symonds - Microsoft MVP (FrontPage)
| >> >> >> >> >> Reply only to group - emails will be deleted unread.
| >> >> >> >> >>
| >> >> >> >> >> http://www.rxs-enterprises.org/fp
| >> >> >> >> >>
| >> >> >> >> >> FrontPage Support: http://www.frontpagemvps.com/
| >> >> >> >> >>
| >> >> >> >> >>
| >> >> >> >> >>
| >> >> >> >> >>
| >> >> >> >> >> message
| >> >> >> >> >> | >> >> >> >> >>
| >> >> >> >> >> > Hi again Thomas
| >> >> >> >> >> >
| >> >> >> >> >> > Sorry about but not too hot with FP.
| >> >> >> >> >> >
| >> >> >> >> >> > I have checked with the host and the site is on IIS with
| >> >> >> >> >> > server extention
| >> >> >> >> >> > and ask support.
| >> >> >> >> >> >
| >> >> >> >> >> > If you put some information on the on-line form it does
| >> >> >> >> >> > show
| >> >> >> >> >> > up in the DB on
| >> >> >> >> >> > the site but not on the C drive. How do I get it from the
| >> >> >> >> >> > site onto our
| >> >> >> >> >> > office machines.
| >> >> >> >> >> >
| >> >> >> >> >> > Once again sorry to ask something that may be simple.
| >> >> >> >> >> >
| >> >> >> >> >> > --
| >> >> >> >> >> > Wayne
| >> >> >> >> >> > Manchester, England.
| >> >> >> >> >> >
| >> >> >> >> >> >
| >> >> >> >> >> >
| >> >> >> >> >> > "Thomas A. Rowe" wrote:
| >> >> >> >> >> >
| >> >> >> >> >> > > It is automatic. Your site must be hosted on a Windows
| >> >> >> >> >> > > IIS
| >> >> >> >> >> > > web server with FPSE,
| >> >> >> >> >> > > ASP/Access
| >> >> >> >> >> > > support
| >> >> >> >> >> > > for this to work.
| >> >> >> >> >> > >
| >> >> >> >> >> > > --
| >> >> >> >> >> > > ==============================================
| >> >> >> >> >> > > Thomas A. Rowe
| >> >> >> >> >> > > Microsoft MVP - FrontPage
| >> >> >> >> >> > >
| >> >> >> >> >> > > http://www.Ecom-Data.com
| >> >> >> >> >> > > ==============================================
| >> >> >> >> >> > >
| >> >> >> >> >> > >
| >> >> >> >> >> > > message
| >> >> >> >> >> > > | >> >> >> >> >> > > > Hi all
| >> >> >> >> >> > > >
| >> >> >> >> >> > > > I have set up a small website with just one asp form
| >> >> >> >> >> > > > and a
| >> >> >> >> >> > > > confirmation
| >> >> >> >> >> > > > page. I have used the wizard to create the database to
| >> >> >> >> >> > > > collect the results
| >> >> >> >> >> > > > of the form. Basically I want someone to fill in the
| >> >> >> >> >> > > > form
| >> >> >> >> >> > > > and results to go
| >> >> >> >> >> > > > into the DB.
| >> >> >> >> >> > > >
| >> >> >> >> >> > > > Question when / how does the information get into the
| >> >> >> >> >> > > > database.
| >> >> >> >> >> > > >
| >> >> >> >> >> > > > Is it automatic - do I need to do something ??
| >> >> >> >> >> > > >
| >> >> >> >> >> > > > Any help would be great
| >> >> >> >> >> > > >
| >> >> >> >> >> > > > --
| >> >> >> >> >> > > > Wayne
| >> >> >> >> >> > > > Manchester, England.
| >> >> >> >> >> > > >
| >> >> >> >> >> > >
| >> >> >> >> >> > >
| >> >> >> >> >> > >
| >> >> >> >> >>
| >> >> >> >> >>
| >> >> >> >>
| >> >> >> >>
| >> >> >> >>
| >> >> >>
| >> >> >>
| >> >> >>
| >> >>
| >> >>
| >> >>
| >>
| >>
| >>
|
|
 
W

Wayne-I-M

Hi Stefan

Thats what I'm trying to avoid. I'm creating a small DLL that will do the
job.

I want users to simply click on an access form button to download new on
line form details. The data will then be allocated to various tables via an
apend after running through validation (people tend to type mistakes into on
line forms).

What I don't want to do is either have to give out our user name and
password to users or (even worse) for me to have to manually open FP and
backup to local disk (bit 1980's that way).

I have googled this and it's seems the Access -> FP is no problem but FP ->
Access is not built in. As I'm the IT dept here I guess it's my job to get
the company software to do what we want. I have already set this up simply
using mysql so could use that but I'm interested in this now - so will sort
it soon (after holidays).

I'm sure life was much simpler when I was aboy with a typewritter :)

--
Wayne
Manchester, England.



Stefan B Rusynko said:
To download (backup) a DB from a FP SE Web site
- just open the online site in FP, select the mdb file and from the menu use File Export and select a location on your PC

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| This is always a problem web designers create a web in frontpage with an
| access database, hand it over to the client and the first thing the client
| askes is "how do I backup the database"
| I do it in frontpage but it is not without its perils.I created another
| local web with just the database folder and then I open the remote site and
| right click the database on the remote site and publish it to the local new
| we. There are some things that can go wrong . first you havr to make sure
| the publish from the remote to local radio button at the bottom right of the
| frontpage screen is selected or the local will overwrite the remote instead
| of the other way round. A simple stand alone download program from the
| remote to the local where all the download criteria (username and password
| and file destinations) can be set by the web designer before you give it to
| the client would be usefull I have come accross such programs for SQL
| databases but not access.
|
| | > Hi Paul
| >
| > I'm not sure about the "backup" approach. If I could back it up it would
| > be
| > on a drive and then I would not have this problem.
| >
| > I normally write access DB's so once I can get the results of an online
| > form
| > on a to drive there will be no problems - I have already written some code
| > to
| > import the data - query it (so that you are not over writting other
| > data) -
| > change the format (as some people don't TYPE In tHE correct case) - print
| > automatic reciepts / confirmation - append it to various tables - etc etc
| > etc.
| >
| > All I need to do is get the data - ha ha ha someone in my office told me
| > it
| > could not be done with frontpage as it was for "people who know nothing
| > about
| > web design". Hmmmmm - so you see I "have to do this".
| >
| > If (when) I work it out I will post a step by step
| >
| > BUT - still no closer to getting the data "without" opening FP and logging
| > in - at home know so will look at it again in the morning
| >
| > Thanks for your input
| >
| > --
| > Wayne
| > Manchester, England.
| >
| >
| >
| > "Paul C" wrote:
| >
| >> HI Have a lok at these, I have never used them.
| >>
| >> http://www.goodsync.com/land/land.php?affid=googs&frm=frame10
| >>
| >> http://free-backup.info/
| >>
| >> let us know how you get on
| >> Paul M
| >>
| >>
| >> | >> > OK I have relooked at the problem (with "lots" of googleing). As I
| >> > have
| >> > set
| >> > it up will not work.
| >> >
| >> > I know that you can save form results to a txt or csv file But the
| >> > same
| >> > question (almost) applies.
| >> >
| >> > Can you export or somehow have the data available onto a drive
| >> > "without"
| >> > going into frontpage -> logging in via user name and password ->
| >> > syncroing
| >> > the datebase (web to local)
| >> >
| >> > I'm still loking for a method of getting form results on a drive
| >> >
| >> > Any hints / tips
| >> >
| >> > Many thanks
| >> > --
| >> > Wayne
| >> > Manchester, England.
| >> >
| >> >
| >> >
| >> > "Thomas A. Rowe" wrote:
| >> >
| >> >> The problem is that the web is not local (unless you are self-hosting
| >> >> (which is not recommend) ,and
| >> >> you are really not using Access (the app) on the web, just it's
| >> >> database.
| >> >>
| >> >> --
| >> >> ==============================================
| >> >> Thomas A. Rowe
| >> >> Microsoft MVP - FrontPage
| >> >>
| >> >> http://www.Ecom-Data.com
| >> >> ==============================================
| >> >>
| >> >>
| >> >> | >> >> > Many thanks for your input Thomas.
| >> >> >
| >> >> > I would have thought that this was exactly what ms office was only
| >> >> > about.
| >> >> > Integrated systems - access, word, outlook, excel, FP, etc. It
| >> >> > seems
| >> >> > that
| >> >> > (from an access form ) I can call all other parts of office other
| >> >> > than
| >> >> > FP.
| >> >> > Takes a little codeing but not too difficult. I know FP uses a
| >> >> > different set
| >> >> > than the others but still .... all it would take would be to be able
| >> >> > to
| >> >> > get a
| >> >> > database from the web on to a drive and it would all work.
| >> >> >
| >> >> > I will get it to work :) (somehow)
| >> >> >
| >> >> > Many thanks again
| >> >> >
| >> >> > --
| >> >> > Wayne
| >> >> > Manchester, England.
| >> >> >
| >> >> >
| >> >> >
| >> >> > "Thomas A. Rowe" wrote:
| >> >> >
| >> >> >> Use a 3rd Party FTP application or you might be able to use Windows
| >> >> >> Scripting to automate the
| >> >> >> download process and overwrite you local version of the database.
| >> >> >>
| >> >> >> --
| >> >> >> ==============================================
| >> >> >> Thomas A. Rowe
| >> >> >> Microsoft MVP - FrontPage
| >> >> >>
| >> >> >> http://www.Ecom-Data.com
| >> >> >> ==============================================
| >> >> >>
| >> >> >>
| >> >> >> | >> >> >> > How would this be done. I can call the database if it is on a
| >> >> >> > drive
| >> >> >> > and over
| >> >> >> > write it with updates without changeing the name so that would
| >> >> >> > work.
| >> >> >> >
| >> >> >> > Any hints and or a web page that gives instructions
| >> >> >> >
| >> >> >> > Many thanks
| >> >> >> >
| >> >> >> > --
| >> >> >> > Wayne
| >> >> >> > Manchester, England.
| >> >> >> >
| >> >> >> >
| >> >> >> >
| >> >> >> > "Thomas A. Rowe" wrote:
| >> >> >> >
| >> >> >> >> Your other option is to use FTP to download the database to your
| >> >> >> >> PC.
| >> >> >> >>
| >> >> >> >> --
| >> >> >> >> ==============================================
| >> >> >> >> Thomas A. Rowe
| >> >> >> >> Microsoft MVP - FrontPage
| >> >> >> >>
| >> >> >> >> http://www.Ecom-Data.com
| >> >> >> >> ==============================================
| >> >> >> >>
| >> >> >> >>
| >> >> >> >> | >> >> >> >> > Hi
| >> >> >> >> >
| >> >> >> >> > Thanks for getting back to me.
| >> >> >> >> >
| >> >> >> >> > I have written a little "stuff" to import the form's data into
| >> >> >> >> > my
| >> >> >> >> > main
| >> >> >> >> > access database. I'm a bit confused by this database that is
| >> >> >> >> > on
| >> >> >> >> > the website.
| >> >> >> >> > The information "is" there (as when I copy it to the hard
| >> >> >> >> > drvie
| >> >> >> >> > it opens
| >> >> >> >> > fine and I can use the data).
| >> >> >> >> >
| >> >> >> >> > But I thought (maybe am wrong) that you should not need to go
| >> >> >> >> > into FrontPage
| >> >> >> >> > and open the DB. Is there not some way to have the data
| >> >> >> >> > passed
| >> >> >> >> > directly to a
| >> >> >> >> > database that can be accessed without opening FP.
| >> >> >> >> >
| >> >> >> >> > --
| >> >> >> >> > Wayne
| >> >> >> >> > Manchester, England.
| >> >> >> >> >
| >> >> >> >> >
| >> >> >> >> >
| >> >> >> >> > "Ronx" wrote:
| >> >> >> >> >
| >> >> >> >> >> Use FrontPage to:
| >> >> >> >> >> 1) Open the site on the server.
| >> >> >> >> >> 2) File->Export the database to your desktop. This copies
| >> >> >> >> >> the
| >> >> >> >> >> database
| >> >> >> >> >> on the website to your desktop.
| >> >> >> >> >>
| >> >> >> >> >> --
| >> >> >> >> >> Ron Symonds - Microsoft MVP (FrontPage)
| >> >> >> >> >> Reply only to group - emails will be deleted unread.
| >> >> >> >> >>
| >> >> >> >> >> http://www.rxs-enterprises.org/fp
| >> >> >> >> >>
| >> >> >> >> >> FrontPage Support: http://www.frontpagemvps.com/
| >> >> >> >> >>
| >> >> >> >> >>
| >> >> >> >> >>
| >> >> >> >> >>
| >> >> >> >> >> message
| >> >> >> >> >> | >> >> >> >> >>
| >> >> >> >> >> > Hi again Thomas
| >> >> >> >> >> >
| >> >> >> >> >> > Sorry about but not too hot with FP.
| >> >> >> >> >> >
| >> >> >> >> >> > I have checked with the host and the site is on IIS with
| >> >> >> >> >> > server extention
| >> >> >> >> >> > and ask support.
| >> >> >> >> >> >
| >> >> >> >> >> > If you put some information on the on-line form it does
| >> >> >> >> >> > show
| >> >> >> >> >> > up in the DB on
| >> >> >> >> >> > the site but not on the C drive. How do I get it from the
| >> >> >> >> >> > site onto our
| >> >> >> >> >> > office machines.
| >> >> >> >> >> >
| >> >> >> >> >> > Once again sorry to ask something that may be simple.
| >> >> >> >> >> >
| >> >> >> >> >> > --
| >> >> >> >> >> > Wayne
| >> >> >> >> >> > Manchester, England.
| >> >> >> >> >> >
| >> >> >> >> >> >
| >> >> >> >> >> >
| >> >> >> >> >> > "Thomas A. Rowe" wrote:
| >> >> >> >> >> >
| >> >> >> >> >> > > It is automatic. Your site must be hosted on a Windows
| >> >> >> >> >> > > IIS
| >> >> >> >> >> > > web server with FPSE,
| >> >> >> >> >> > > ASP/Access
| >> >> >> >> >> > > support
| >> >> >> >> >> > > for this to work.
| >> >> >> >> >> > >
| >> >> >> >> >> > > --
| >> >> >> >> >> > > ==============================================
| >> >> >> >> >> > > Thomas A. Rowe
| >> >> >> >> >> > > Microsoft MVP - FrontPage
| >> >> >> >> >> > >
| >> >> >> >> >> > > http://www.Ecom-Data.com
| >> >> >> >> >> > > ==============================================
| >> >> >> >> >> > >
| >> >> >> >> >> > >
| >> >> >> >> >> > > message
| >> >> >> >> >> > > | >> >> >> >> >> > > > Hi all
| >> >> >> >> >> > > >
| >> >> >> >> >> > > > I have set up a small website with just one asp form
| >> >> >> >> >> > > > and a
| >> >> >> >> >> > > > confirmation
| >> >> >> >> >> > > > page. I have used the wizard to create the database to
 
S

Stefan B Rusynko

You can open an instance of FP (then file export) from within Access in VBA
- the FP credentials would be in the Access VBA
See http://msdn2.microsoft.com/en-us/library/aa208502(office.11).aspx

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Hi Stefan
|
| Thats what I'm trying to avoid. I'm creating a small DLL that will do the
| job.
|
| I want users to simply click on an access form button to download new on
| line form details. The data will then be allocated to various tables via an
| apend after running through validation (people tend to type mistakes into on
| line forms).
|
| What I don't want to do is either have to give out our user name and
| password to users or (even worse) for me to have to manually open FP and
| backup to local disk (bit 1980's that way).
|
| I have googled this and it's seems the Access -> FP is no problem but FP ->
| Access is not built in. As I'm the IT dept here I guess it's my job to get
| the company software to do what we want. I have already set this up simply
| using mysql so could use that but I'm interested in this now - so will sort
| it soon (after holidays).
|
| I'm sure life was much simpler when I was aboy with a typewritter :)
|
| --
| Wayne
| Manchester, England.
|
|
|
| "Stefan B Rusynko" wrote:
|
| > To download (backup) a DB from a FP SE Web site
| > - just open the online site in FP, select the mdb file and from the menu use File Export and select a location on your PC
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > _____________________________________________
| >
| >
| > | This is always a problem web designers create a web in frontpage with an
| > | access database, hand it over to the client and the first thing the client
| > | askes is "how do I backup the database"
| > | I do it in frontpage but it is not without its perils.I created another
| > | local web with just the database folder and then I open the remote site and
| > | right click the database on the remote site and publish it to the local new
| > | we. There are some things that can go wrong . first you havr to make sure
| > | the publish from the remote to local radio button at the bottom right of the
| > | frontpage screen is selected or the local will overwrite the remote instead
| > | of the other way round. A simple stand alone download program from the
| > | remote to the local where all the download criteria (username and password
| > | and file destinations) can be set by the web designer before you give it to
| > | the client would be usefull I have come accross such programs for SQL
| > | databases but not access.
| > |
| > | | > | > Hi Paul
| > | >
| > | > I'm not sure about the "backup" approach. If I could back it up it would
| > | > be
| > | > on a drive and then I would not have this problem.
| > | >
| > | > I normally write access DB's so once I can get the results of an online
| > | > form
| > | > on a to drive there will be no problems - I have already written some code
| > | > to
| > | > import the data - query it (so that you are not over writting other
| > | > data) -
| > | > change the format (as some people don't TYPE In tHE correct case) - print
| > | > automatic reciepts / confirmation - append it to various tables - etc etc
| > | > etc.
| > | >
| > | > All I need to do is get the data - ha ha ha someone in my office told me
| > | > it
| > | > could not be done with frontpage as it was for "people who know nothing
| > | > about
| > | > web design". Hmmmmm - so you see I "have to do this".
| > | >
| > | > If (when) I work it out I will post a step by step
| > | >
| > | > BUT - still no closer to getting the data "without" opening FP and logging
| > | > in - at home know so will look at it again in the morning
| > | >
| > | > Thanks for your input
| > | >
| > | > --
| > | > Wayne
| > | > Manchester, England.
| > | >
| > | >
| > | >
| > | > "Paul C" wrote:
| > | >
| > | >> HI Have a lok at these, I have never used them.
| > | >>
| > | >> http://www.goodsync.com/land/land.php?affid=googs&frm=frame10
| > | >>
| > | >> http://free-backup.info/
| > | >>
| > | >> let us know how you get on
| > | >> Paul M
| > | >>
| > | >>
| > | >> | > | >> > OK I have relooked at the problem (with "lots" of googleing). As I
| > | >> > have
| > | >> > set
| > | >> > it up will not work.
| > | >> >
| > | >> > I know that you can save form results to a txt or csv file But the
| > | >> > same
| > | >> > question (almost) applies.
| > | >> >
| > | >> > Can you export or somehow have the data available onto a drive
| > | >> > "without"
| > | >> > going into frontpage -> logging in via user name and password ->
| > | >> > syncroing
| > | >> > the datebase (web to local)
| > | >> >
| > | >> > I'm still loking for a method of getting form results on a drive
| > | >> >
| > | >> > Any hints / tips
| > | >> >
| > | >> > Many thanks
| > | >> > --
| > | >> > Wayne
| > | >> > Manchester, England.
| > | >> >
| > | >> >
| > | >> >
| > | >> > "Thomas A. Rowe" wrote:
| > | >> >
| > | >> >> The problem is that the web is not local (unless you are self-hosting
| > | >> >> (which is not recommend) ,and
| > | >> >> you are really not using Access (the app) on the web, just it's
| > | >> >> database.
| > | >> >>
| > | >> >> --
| > | >> >> ==============================================
| > | >> >> Thomas A. Rowe
| > | >> >> Microsoft MVP - FrontPage
| > | >> >>
| > | >> >> http://www.Ecom-Data.com
| > | >> >> ==============================================
| > | >> >>
| > | >> >>
| > | >> >> | > | >> >> > Many thanks for your input Thomas.
| > | >> >> >
| > | >> >> > I would have thought that this was exactly what ms office was only
| > | >> >> > about.
| > | >> >> > Integrated systems - access, word, outlook, excel, FP, etc. It
| > | >> >> > seems
| > | >> >> > that
| > | >> >> > (from an access form ) I can call all other parts of office other
| > | >> >> > than
| > | >> >> > FP.
| > | >> >> > Takes a little codeing but not too difficult. I know FP uses a
| > | >> >> > different set
| > | >> >> > than the others but still .... all it would take would be to be able
| > | >> >> > to
| > | >> >> > get a
| > | >> >> > database from the web on to a drive and it would all work.
| > | >> >> >
| > | >> >> > I will get it to work :) (somehow)
| > | >> >> >
| > | >> >> > Many thanks again
| > | >> >> >
| > | >> >> > --
| > | >> >> > Wayne
| > | >> >> > Manchester, England.
| > | >> >> >
| > | >> >> >
| > | >> >> >
| > | >> >> > "Thomas A. Rowe" wrote:
| > | >> >> >
| > | >> >> >> Use a 3rd Party FTP application or you might be able to use Windows
| > | >> >> >> Scripting to automate the
| > | >> >> >> download process and overwrite you local version of the database.
| > | >> >> >>
| > | >> >> >> --
| > | >> >> >> ==============================================
| > | >> >> >> Thomas A. Rowe
| > | >> >> >> Microsoft MVP - FrontPage
| > | >> >> >>
| > | >> >> >> http://www.Ecom-Data.com
| > | >> >> >> ==============================================
| > | >> >> >>
| > | >> >> >>
| > | >> >> >> | > | >> >> >> > How would this be done. I can call the database if it is on a
| > | >> >> >> > drive
| > | >> >> >> > and over
| > | >> >> >> > write it with updates without changeing the name so that would
| > | >> >> >> > work.
| > | >> >> >> >
| > | >> >> >> > Any hints and or a web page that gives instructions
| > | >> >> >> >
| > | >> >> >> > Many thanks
| > | >> >> >> >
| > | >> >> >> > --
| > | >> >> >> > Wayne
| > | >> >> >> > Manchester, England.
| > | >> >> >> >
| > | >> >> >> >
| > | >> >> >> >
| > | >> >> >> > "Thomas A. Rowe" wrote:
| > | >> >> >> >
| > | >> >> >> >> Your other option is to use FTP to download the database to your
| > | >> >> >> >> PC.
| > | >> >> >> >>
| > | >> >> >> >> --
| > | >> >> >> >> ==============================================
| > | >> >> >> >> Thomas A. Rowe
| > | >> >> >> >> Microsoft MVP - FrontPage
| > | >> >> >> >>
| > | >> >> >> >> http://www.Ecom-Data.com
| > | >> >> >> >> ==============================================
| > | >> >> >> >>
| > | >> >> >> >>
| > | >> >> >> >> | > | >> >> >> >> > Hi
| > | >> >> >> >> >
| > | >> >> >> >> > Thanks for getting back to me.
| > | >> >> >> >> >
| > | >> >> >> >> > I have written a little "stuff" to import the form's data into
| > | >> >> >> >> > my
| > | >> >> >> >> > main
| > | >> >> >> >> > access database. I'm a bit confused by this database that is
| > | >> >> >> >> > on
| > | >> >> >> >> > the website.
| > | >> >> >> >> > The information "is" there (as when I copy it to the hard
| > | >> >> >> >> > drvie
| > | >> >> >> >> > it opens
| > | >> >> >> >> > fine and I can use the data).
| > | >> >> >> >> >
| > | >> >> >> >> > But I thought (maybe am wrong) that you should not need to go
| > | >> >> >> >> > into FrontPage
| > | >> >> >> >> > and open the DB. Is there not some way to have the data
| > | >> >> >> >> > passed
| > | >> >> >> >> > directly to a
| > | >> >> >> >> > database that can be accessed without opening FP.
| > | >> >> >> >> >
| > | >> >> >> >> > --
| > | >> >> >> >> > Wayne
| > | >> >> >> >> > Manchester, England.
| > | >> >> >> >> >
| > | >> >> >> >> >
| > | >> >> >> >> >
| > | >> >> >> >> > "Ronx" wrote:
| > | >> >> >> >> >
| > | >> >> >> >> >> Use FrontPage to:
| > | >> >> >> >> >> 1) Open the site on the server.
| > | >> >> >> >> >> 2) File->Export the database to your desktop. This copies
| > | >> >> >> >> >> the
| > | >> >> >> >> >> database
| > | >> >> >> >> >> on the website to your desktop.
| > | >> >> >> >> >>
| > | >> >> >> >> >> --
| > | >> >> >> >> >> Ron Symonds - Microsoft MVP (FrontPage)
| > | >> >> >> >> >> Reply only to group - emails will be deleted unread.
| > | >> >> >> >> >>
| > | >> >> >> >> >> http://www.rxs-enterprises.org/fp
| > | >> >> >> >> >>
| > | >> >> >> >> >> FrontPage Support: http://www.frontpagemvps.com/
| > | >> >> >> >> >>
| > | >> >> >> >> >>
| > | >> >> >> >> >>
| > | >> >> >> >> >>
| > | >> >> >> >> >> message
| > | >> >> >> >> >> | > | >> >> >> >> >>
| > | >> >> >> >> >> > Hi again Thomas
| > | >> >> >> >> >> >
| > | >> >> >> >> >> > Sorry about but not too hot with FP.
| > | >> >> >> >> >> >
| > | >> >> >> >> >> > I have checked with the host and the site is on IIS with
| > | >> >> >> >> >> > server extention
| > | >> >> >> >> >> > and ask support.
| > | >> >> >> >> >> >
| > | >> >> >> >> >> > If you put some information on the on-line form it does
| > | >> >> >> >> >> > show
| > | >> >> >> >> >> > up in the DB on
| > | >> >> >> >> >> > the site but not on the C drive. How do I get it from the
| > | >> >> >> >> >> > site onto our
| > | >> >> >> >> >> > office machines.
| > | >> >> >> >> >> >
| > | >> >> >> >> >> > Once again sorry to ask something that may be simple.
| > | >> >> >> >> >> >
| > | >> >> >> >> >> > --
| > | >> >> >> >> >> > Wayne
| > | >> >> >> >> >> > Manchester, England.
| > | >> >> >> >> >> >
| > | >> >> >> >> >> >
| > | >> >> >> >> >> >
| > | >> >> >> >> >> > "Thomas A. Rowe" wrote:
| > | >> >> >> >> >> >
| > | >> >> >> >> >> > > It is automatic. Your site must be hosted on a Windows
| > | >> >> >> >> >> > > IIS
| > | >> >> >> >> >> > > web server with FPSE,
| > | >> >> >> >> >> > > ASP/Access
| > | >> >> >> >> >> > > support
| > | >> >> >> >> >> > > for this to work.
| > | >> >> >> >> >> > >
| > | >> >> >> >> >> > > --
| > | >> >> >> >> >> > > ==============================================
| > | >> >> >> >> >> > > Thomas A. Rowe
| > | >> >> >> >> >> > > Microsoft MVP - FrontPage
| > | >> >> >> >> >> > >
| > | >> >> >> >> >> > > http://www.Ecom-Data.com
| > | >> >> >> >> >> > > ==============================================
| > | >> >> >> >> >> > >
| > | >> >> >> >> >> > >
| > | >> >> >> >> >> > > message
| > | >> >> >> >> >> > > | > | >> >> >> >> >> > > > Hi all
| > | >> >> >> >> >> > > >
| > | >> >> >> >> >> > > > I have set up a small website with just one asp form
| > | >> >> >> >> >> > > > and a
| > | >> >> >> >> >> > > > confirmation
| > | >> >> >> >> >> > > > page. I have used the wizard to create the database to
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top