Solved

Building a web interface using frontpage and Access Database

Posted on 2004-09-14
3
154 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
Objective of This Article In 1990’s, when I was a budding software professional, I had a lot of confusion about which stream or technology, I had to choose to build my career. In those days, I had lot of confusion like whether to choose System so…
The purpose of this video is to demonstrate how to connect a WordPress website to Google Analytics. This will be demonstrated using a Windows 8 PC Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php :…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

911 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

20 Experts available now in Live!

Get 1:1 Help Now