Solved

Building a web interface using frontpage and Access Database

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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
New Website 15 31
What website technology to use for a real estate listing business? 2 94
USPS CityStateLookup question 3 83
Search on a site 5 112
When deciding to adopt any help desk solutions many factors should be explored before taking decisions. This will change from business to another but in general there are some kind of rule of thumb. Here are some quick tips: Do we need only ticket…
In this short web based tutorial, I wanted to show users how they can still use the powers of FrontPage in conjunction with Expression Web 3.  Even though Microsoft eliminated the use of Web components, we can still use them with FrontPage and edit …
The purpose of this video is to demonstrate how to manually back up a WordPress Database. This will be demonstrated using a Windows 8 PC. The Host used will be IPage.com Log into your Hosting account. IPage will be used for demonstration : Locat…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. 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 : Go t…

808 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