TechSpot

Janes · #1 02-20-2007

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

jobeard · #2 02-20-2007

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)

Janes · #3 02-21-2007

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

jobeard · #4 02-21-2007

Quote:

Originally Posted by 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.

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.

Similar Topics
Topic	Replies	Forum
C programming	13	Software Apps
Programming	13	Software Apps
Need Programming Help!!!	4	Software Apps
programming	3	Gaming
Need programming help!	1	Site Feedback and Suggestions

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

TechSpot

Programming Anyone??