TechSpot

Programming Anyone??

By Janes
Feb 20, 2007
  1. Hey guys, i hope someone can help me.

    I have created several Tables and forms and macros and reports in Microsoft access. they all link to the same databse which is constructed by the tables (certain fields related).

    Now i need to integrate that with my Intranet, Google isnt really helping and my brain feels like to guy who played Lord of the Rings: Rise of the WitchKing against me this weekend, :-( LOST and TIRED!!! so if anyone can help??

    Plz!!

    Thank you very much!!
     
  2. jobeard

    jobeard TS Ambassador Posts: 9,311   +617

    Internet access to a DMBS (eg Access) has this data flow:
    Code:
    the browser[1]
       has a web page
       usually some < form data >
       click submit -------> http GET or POST ---> webserver[2]
    
    
       ---> webserver[2] -- runs the requested CGI program
                                     |
                                     |
                                     which accesses the DBMS
                                     reads the query results
                                     formats a HTTP reply
        browser[2] <----------------- and writes it to STDOUT
    
    So you need
    1) HTML coding for the browser,
    2) CGI programming to receive the request (eg PHP,Perl)
    3) and an API to connect/query to your Access DBMS
    (btw: it needs to be on the webserver, not your pc)
     
  3. Janes

    Janes TS Rookie Topic Starter Posts: 63

    Ok, but is there a way that i can display a form created in Microsoft Access in my HTML page. that is my main concern at this stage.

    Man this is giving me headaches!!

    ciao
     
  4. jobeard

    jobeard TS Ambassador Posts: 9,311   +617

    Not that I know of :(
    Access is a GUI front end to SQL Tables, and has NOTHING to do with HTML.

    I distain MS products, but firmly believe that you can not get to an Access
    table even when running IIS on a MS platform -- MySQL would be the preferred
    DBMS.

    Your sole choice is ODBC mapping of the Access table(s) running from a CGI program
    driven by IIS. The previous data flow is Web Server data flow for
    webpage->form->cgi->dbms on ANY platform.

    Your Access tables might be usable on a Network Mapped drive, but that's your last hope imo.
     
Topic Status:
Not open for further replies.

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...