Solved

Building a web interface using frontpage and Access Database

Posted on 2004-09-14
3
153 Views
Last Modified: 2013-12-24
I may be confused but maybe not. The person I am working with on this project and I are having a debate. Thought I could get some help as I am not the network person. I know only enough to get by on the network side. Also this is a much larger project than I am used too.

I am in the process of creating an intranet site for my company using frontpage 2003. We are using Frontpage server extensions not Sharepoint services. We are using an Access database that is SQL server based. I am now ready to create the pages and connect to the Data source. My Idea is to create a new blank page and insert the database and connect as I go and save as an .asp. The person I am working with however says that I cannot do this and should create the pages by inserting tables and buttons and dropdown boxes etc. and than connect the backend to the data source by programming with ASP.Net or as he says .aspx. I feel as if I will be creating more work than is really needed and possibly creating my pages more than once if I do the later. Everywhere I have researched I get the same way to insert a database but the otherside is saying because of the .aspx I cannot do this. My lack of experience can't see why I can't

My question would be is there another solution or what is the best way to go about the creation of this intranet?

0
Comment
Question by:kmoyer9717
3 Comments
 
LVL 12

Accepted Solution

by:
rcmb earned 100 total points
ID: 12080832
What you are suggesting is correct. You can easily create a new page and then insert the database connection and save as an ASP. In FP you can use the database connection wizard to build your connections for you and build the display format at the same time. You can import your access database directly into your web or build your ODBC connection and then use it.

Database connectivity is very simple in FP but it has it limitations. I personally get frustated with the inability to manipulate the connection string and my SQL statement. In FP you can only pass data to a query from a form or from your URL. Where as in VBScript you can use variables and such.

I think your friend has lost the bet. FP will do most of the work for you and save you hours of creating layouts, forms, tables, etc.

RCMB
0
 

Author Comment

by:kmoyer9717
ID: 12093713
I wanted to say thank you for the time you took to answer my question. All the research I have done kept coming back to the same answer.

Thank you again.
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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…
When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
The purpose of this video is to demonstrate how to automatically show related posts at the bottom of a blog post in WordPress. This will be demonstrated using a Windows 8 PC. Plugin “Yet Another Related Posts Plugin” will be used. Go to your…
The purpose of this video is to demonstrate how to set up basic WordPress SEO. This will be demonstrated using a Windows 8 PC. The plugin used will be WordPress SEO by Yoast. Go to your WordPress login page. This will look like the following: myw…

705 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

16 Experts available now in Live!

Get 1:1 Help Now