Solved

Building a web interface using frontpage and Access Database

Posted on 2004-09-14
3
157 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
LMS Tracking Survey Result 1 53
USPS CityStateLookup question 3 93
Problem to get function 52 116
SPLUNK REST  API call to Splunk to create and index? 2 160
This article provides a case study on how our local youth baseball league deployed a new website, including the platform selection, implementation and benefits to the league.
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 properly insert a Vimeo Video into a WordPress site or Blog. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp…
The purpose of this video is to demonstrate how to Test the speed of a WordPress Website. Site Speed is an important metric of a site’s health. Slow site speed can result in viewers leaving your site quickly and not seeing your content. This…

730 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