Frontpage results to access DB

[Guest]

Hi all

Is there a website or helps page that gives step by step instructions for
getting the results of a form on a frongpage web into an access database.

Many thanks

 

[Guest]

It's OK - I worked it out.

Many thanks

 

[md Webs Unlimited]

Glad you got it working.

--
Mike - FrontPage MVP '97 - '02
Expression Tools & Addin
http://www.j-moves.com
http://www.panemanager.com
FrontPage Tools & Addin
http://www.jbots.com
E-Commerce
http://www.candypress.com

 

[Guest]

Hi Mike

It still not very good "to say the least". I will write something to get it
working OnClick from access. But - I would have though that this would have
been included in FP - it's part of office after-all.

I can write access "stuff" to pass a variable (username password) after
calling the FP exe, but I thought FP was sold as "not codeing required".

Is there not a standard function/module/?? for this.


--
Wayne
Manchester, England.

Glad you got it working.

--
Mike - FrontPage MVP '97 - '02
Expression Tools & Addin
http://www.j-moves.com
http://www.panemanager.com
FrontPage Tools & Addin
http://www.jbots.com
E-Commerce
http://www.candypress.com

 

[vey]

Hi Mike

It still not very good "to say the least". I will write something to get it
working OnClick from access. But - I would have though that this would have
been included in FP - it's part of office after-all.

I can write access "stuff" to pass a variable (username password) after
calling the FP exe, but I thought FP was sold as "not codeing required".

Is there not a standard function/module/?? for this.

I'm confused by what you say you want to do.
If you have FP 2003 and a website using, I think only Windows Server,
and the latest FrontPage Server extension (without Sharepoint extensions
installed), then you should be able to use the "Database Interface
Wizard using ASP" to create a new subwebsite just to handle the
database. Look in the help section for a step-by-step.

I just did this while connected directly to the website, not on a local
drive and uploading. I think that is the best way (could be the only
way) to do this.

The database should be in the fpdb folder.

After it is created, don't use any more FP wizards or helpers to
maintain it. If, for example, you want to upload new data rather than
going through the web interface, then the best way is to use FP to
connect directly to the server and working live, rename the database
file. You will be prompted if you want FP to fix the connection, say no.
Then upload the new database file. That file *MUST* have *EXACTLY* the
same name and that means CASE COUNTS. AND the TABLE inside must also
have EXACTLY the same name.

If you do it this way, then you won't break the global.asa file. It took
me a long time to figure out this trick and it would come in handy for
you if you wanted to download the database for editing off-line.

 

[Guest]

Hi Vey

Thanks for the tips. What I need is a method of getting the database backed
up to a hard drive.

If I user inputs data onto an online form I need a method of getting that
information onto a drive so that I can use it.

At the moment the only way I can see is to open FP. Put in username and
password then inport the data on the hard drive then log our of FP.

I am looking for a method of simply backing up (downloading the data) the FP
database - with out inputting username password inport logout.

 

[Ronx]

The database is (correctly) placed in a folder where you MUST use a
userid and password to access it, unless you have a web based online
application to manipulate it. The folder does not allow anonymouse
browse access. This application will require some coding skills to
extract and download the database contents.

If your host permits FTP access to the web, then set up a file to access
the web and download the database file, using the Windows FTP engine.
The FTP access can be confined (if the host supports this) to the fpdb
folder by setting up a unique FTP account pointing to this folder.

See http://support.microsoft.com/kb/96269 for an example.
--
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/