Newby question - database asp

[Wayne-I-M]

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

 

[Thomas A. Rowe]

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
==============================================

 

[Wayne-I-M]

Many thanks Thomas

I will move the site from my C to the S (the server) which has IIS

--
Wayne
Manchester, England.

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
==============================================

 

[Wayne-I-M]

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.

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
==============================================

 

[Ronx]

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/

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-I-M]

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.

 

[Ronx]

If you have MS SQL Server then yes - this should be accessible from both
the web pages and wherever there is network access to the server.
Access databases do not work on websites when they are also being used
by the Access program - so it's generally a case of either use the
database on a web site, or on the desktop, but not both.

If the server is on your network then you could use Windows Explorer to
copy it. But this should only be done when there is no web activity, or
the database could be corrupted.

It is also possible to write asp pages that will deliver the database
contents as a .csv file that can be imported into your main Access
database.
--
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/

 

[Thomas A. Rowe]

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
==============================================

 

[Wayne-I-M]

Thanks

I was trying the stay away from csv or txt but looks like I've no choice :-(

I would not have thought that FrontPage was not still using the file
extentions I used at school. txt is a bit 1970's.

I thought that FP and access (being part of office) would be be much
simpler. I can shellcall to excel word etc but not it seems FP.

What I was looking for an OnClick from an access form to upgrade a table
with what ever someone had put on to an on-line form. It really should be
simple

I can do the "on-click" code simply, it's just I'm not good with FP. Other
than txt or csv is there a way to get the site database onto the (any) drive
??

 

[Wayne-I-M]

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

 

[Ronx]

FTP
FrontPage File->Export
Windows Explorer copy (if server is on your network)

In your situation it seems Access is not the best choice of database -
SQL Server would be better.

--
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/

 

[Thomas A. Rowe]

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
==============================================

 

[Wayne-I-M]

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

 

[Thomas A. Rowe]

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
==============================================

 

[Wayne-I-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

 

[Ronx]

Set up a batch file (.bat) that fires up the Windows FTP engine and
downloads the file. I have seen this done using a macro in Visual
FoxPro that uploads/downloads files to and from a Unix server.
--
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/

 

[Paul C]

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

 

[Wayne-I-M]

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

 

[Paul C]

If only there where a simple to understand stand alone program which could
easily backup your access database to your hard drive without the use of
frontpage. I recon at the right price you could make a bit.
Paul M

 

[Wayne-I-M]

Hmmmmm - I like that idea. Many many thanks.

I will look at it again in the morning at work

Thanks again for you help