Programming Anyone??

[Janes]

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!!

 

[DelJo63]

Internet access to a DMBS (eg Access) has this data flow:

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)

 

[Janes]

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

 

[DelJo63]

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.

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.