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

Front Page and Access Databases

I am running Front Page 2000 and IIS3 on an NT4.0 SP5 Server.

I have created an access database with Access'97.  I can't create a web page to display the content of the database.

When I browse the page in IE5 or Netscape 4, all I get are the table headings.

Is there anywhere I can get step by step instructions to walk me through installation of all required components and creation of a sample web page to browse a database?
0
akb
Asked:
akb
  • 4
  • 3
  • 3
  • +2
1 Solution
 
leonjoramosCommented:
Look at the MSDN Microsoft developers network, if you suscribe you will get two cd's wirh the Knowledge Base.

then you have two choices:

a) Try getting Active server pages SDK and buuild an applet that will connect via ODBC with you database so you will have querys on demand. There are samples in the ASP CD.

b) You can design a Report that, then you can export thatreport to HTML

0
 
NickRackhamCommented:
leon,

mail me at nick_rackham@msn.com and I'll mail you back a sample database with html and asp pages that show you how to create pages that update insert delete records in a database plus how to display tables to your requiremants on a web page.

Regards

Nick
0
 
NickRackhamCommented:
sorry, that comment was addressed to akb not leon. My mistake.
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
akbAuthor Commented:
Thanks for the comments. I would like to keep the question open for a while for further comment.
0
 
SiteSeeCommented:
Are you certain you have data entered into your database...you would, of course only see headings if that were the case...
make sure you're SQL query is really hitting the Table..Field you want..if you see the table headings...and they are actually dynamically being written from the database, and not "hand-typed" on the page, you're query is working.

Steve
0
 
zs6phdCommented:
Have you created an html front-end using Access 97, or are you trying to use FP 2000 to access the Access database?
If the latter, you can add some neat asp code to your pages to give you much better control. If you like this idea, please post a message and I will provide sample code and some useful links.

Peter
0
 
akbAuthor Commented:
I've tried using both methods.  I am interested in anything that may help.

I didn't "hand'type" the headings.  If I expand the data area of the table on the html page in FrontPage, when I view the page in a browser, the headings are stretched to fill the data area.  If I preview the page in FrontPage, this does not happen.  I have tested using IE5 & Netscape 4.5.
0
 
SiteSeeCommented:
Well then those "headings are being "pulled" from your database...which means the query(as you have it written) WORKS...
There is either NO DATA in the database to display, or your object references in your template page are not written correctly...
e.g.
<%response.write((rs.fields("YourDatabaseFieldName")))%>


Steve
0
 
akbAuthor Commented:
Hello SiteSee, I am VERY new at web development, so I don't really know what I am doing.

I don't think the Front Page manual or Help tells me anywhere that I need to write template pages.

I really think I need step-by-step instructions.  Is there anywhere on the www that will provide me with this?

Thanks,

akb
0
 
SiteSeeCommented:
This is a tutorial for creating a dynamically driven product database...
it assumes, though, that you have downloaded and are working with the sample database that comes with the SalesCart shopping cart software(free demo)...
http://www.salescart.com/support/tn-003.htm 

....it is a step-by-step tutorial on building a dynamic product site with FrontPage and Access

hope this helps...

Steve

0
 
akbAuthor Commented:
NickRackHam, please post an answer and claim the points.
Thanks for all the help.
0
 
NickRackhamCommented:
Answer as requested, Glad to help.

Nick
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 4
  • 3
  • 3
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now