Programming Anyone??

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

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)

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

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.