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