FrontPage and Microsoft Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does FrontPage have the functionality to enable me to build a portion of a
'directory/index' webpage like the example below?

Cat 1 (X) Cat 2 (X) Cat 3 (X) Cat 4 (X) ...
Cat 197 (X) Cat198 (X) Cat199 (X) Cat200 (X)

Where X is the total number of entries found in an Microsoft Access database.

If I then navigate to Cat 1, I would see the entries listed in alphabetical
order.

I would need to regenerate the webpage periodically (and republish it).

Best regards,
Peter
 
You would have to custom write the ASP / VBScript to accomplish what you want. Your site would have
to be hosted on a Windows IIS web server.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage
==============================================
Agents Real Estate Listing Network
http://www.NReal.com
==============================================
 
Thomas,

Do you know whether another product (e.g., ColdFusion) would remove the need
to write custom code?

Thanks,
Peter
 
Cold Fusion is also a scripting language that you'd have to learn. Search
the web, there are a lot of ASP code samples out there you can use to start
with.
 
Yes, you could do this with Access and Frontpage, especially if you
know your way around Access. The solution is not as slick as could be
done using coding (maybe it's even a little ugly) but it could be
done.

In Access you could have all the Cat's, and you can make a queries for
each Cat that returns the number in that Cat. YOu can also make
queries that list all the entries in a CAT in alphabetical order. Us
the Access query builder to do these, and later, copy the sql from the
sql view of the querys for use with the database results wizard of FP

Then you make a webpage set up as shown below where you might set up a
table structure to display the Cat's and the (X's) (now I am assuming
you would manually type in Cat1, Cat2, etc and that these are not
constantly changing -- if you are intending that the Cat1, Cat2 etc
are automatically generated on the page, well, go back to the previous
answers -- you need coding):
Cat 1 (X) Cat 2 (X) Cat 3 (X) Cat 4 (X) ...
Cat 197 (X) Cat198 (X) Cat199 (X) Cat200 (X)
Click to expand...

And in every X location, insert a database results using the query
that generates the number in that category.

Then generate a separate page for each CAT and on that page put a
database results section that uses a query (designed in Access) that
returns the entries in that CAT in alphabetical order.

Then hyperling each CAT from the table iist above to the corresponding
CAT page that returns the listings in alphabetical order.

Like I said, maybe not the slickest, but it would work. Especially if
you have a modest number of CAT's. But if you had a really large
number, you would want a better (read coded) way that was more
automated.
 
Back
Top