Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2004
    Posts
    17

    Unanswered: Using access DB as search tool on website

    I'm not sure this is the right forum for this, but I'll give it a shot.

    What i want to do is take either an excel database or an access database of a catalog of animals.

    The columns would be (Phylum, Family, Genus, Species, PIcture Number) for instance.

    I want to set this up in a series of drop-down boxes, and search forms so that it looks like this.

    PAGE

    [Drop down box with choices of Phylum]

    [Drop down box of the choices of families within that Phylum]

    [Drop down box of Genuses in that Family]

    [Drop down box/or search box of the species in that genus]

    After a species is selected, I want it to pop up with all of the corresponding information on it (IE, its latin name, where it is located , what GPS coordinates it was found at, and on the right, I want a picture of it to pop up) I can sort the pictures in any way, I just don't know how to approach it.

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    There is certainly a way to accomplish this. Do you know any ASP?
    That which does not kill me postpones the inevitable.

  3. #3
    Join Date
    Jun 2004
    Posts
    17

    Talking

    I have never had any exposure to these languages (ASP, mysql), I am a quick learner though.

    I heard a rumor that mysql would be the easiest language to do this with, if not, by all means I would love some instruction.

  4. #4
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    If you've never used MySQL before, it's not necessarily the easiest, but it's better then using Access, and free. If you're not planning to have many people hitting the DB and you're familiar with Access, that may be the way to go.

    Before you can start with ASP you need to have an IIS server setup. Do you have at least that much?
    That which does not kill me postpones the inevitable.

  5. #5
    Join Date
    Jun 2004
    Posts
    17
    Possibly, is that something I can install?

    Sorry that I'm such a newbie
    Last edited by jwortley; 06-04-04 at 13:51.

  6. #6
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    What OS are you running?
    That which does not kill me postpones the inevitable.

  7. #7
    Join Date
    Jun 2004
    Posts
    17
    I am running Microsoft XP Pro on my computer.. the one the website is on is Linux

  8. #8
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    ah... so you want to write a web app that runs on Linux to which interfaces with a DB containing data that you currently have in Excel and Acces..

    That's why someone recommended MySQL. Look into PHP as the scripting language instead of ASP, but what you're attempting to accomplish is entirely possible.
    That which does not kill me postpones the inevitable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •