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?
LVL 13
akbAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.