• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 165
  • Last Modified:

Building a web interface using frontpage and Access Database

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
kmoyer9717
Asked:
kmoyer9717
1 Solution
 
rcmbCommented:
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
 
kmoyer9717Author Commented:
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

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now