Solved

front page 2000

Posted on 2000-04-19
3
194 Views
Last Modified: 2013-12-24
I want to submit my formdata into a default database i.e. ms access( in case of front page 2000) could you pls tell me whether to use ODBC or microsoft's ADO and how? Should i install front page server extensions in order to resolve my problem? If yes why should i use the same. Please help me in successful postage and retrieval of data thru database connectivity options available in front page 2000.
0
Comment
Question by:shailesh_116
  • 2
3 Comments
 
LVL 3

Expert Comment

by:fibdev
ID: 2736492
More information is needed.

Will this be a remote database or a local web site?

Either way, I would say yes.  You want to install FrontPage server extentions to get the most out of frontpage.  Without them you lose the ability to edit on the server.

With the FrontPage server extentions installed. here is all you do to connect to an access database.

1) Create the database.

2) Open the web in frontpage (local or remote, same procedure)

3) From the root select "Inport" from the "File" menu.

4) Select the access database to inport.

5) Frontpage will prompt you with a message that says the database should be stored in a file called "fpdb" say yes and the file will be created and the database will be inported there.  At this point frontpage will automaticlly handle the odbc linking for you.

6) Then you just create a page with a form on it and use frontpage to specify the database to store the results in (in the form "right-click" and select "form properties" a dialog box appears that is pretty self explanitory.

Good Luck
0
 
LVL 2

Expert Comment

by:sduell
ID: 2785083
fibdev is almost entirely correct, except a few steps were left out.
1. You will still need to click on your Control Panel's ODBC32 icon and then setup a DSN name for your database.
2. You will need to go in afterwards to MSFP's web site options for this web site and after clicking on the database tab, double-click on your database's name (in the list) to have MSFP verify your database connection.

I realize this is an incomplete answer, but a real tutorial would be to lengthy to put in this location.  

Best wishes

0
 
LVL 2

Accepted Solution

by:
sduell earned 200 total points
ID: 2848781
Shailesh 116,
did my solution help you out? We haven't heard from you in a while.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Where is this variable set with(in) php SMARTY? 5 163
Web Developer 7 268
Migrating PC with Oracle TOAD installed. 5 39
bootstrap align photos when printing 10 76
Now that Expression Web 4.0 (http://www.microsoft.com/expression/products/Upgrade.aspx) is free if you buy or have the full version of Expression Web 3.0, now is the best time to  migrate from FrontPage to Expression Web (http://www.frontpage-to-exp…
Turn A Profile Picture Into A Cartoon Using Photoshop And Illustrator This tutorial will teach you how to make a cartoon style image out of a regular picture. I have tried to keep the tutorial as simple as possible. I used Adobe CS4 for this tuto…
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now