Combining MS Access with a Web Page

[Darrenb]

I am not too sure that I am posting this on the correct board, so feel free to tell me so!!!

I would like to have a web page that is able to query a Micro$oft Access database. I would ideally like the user to be able to type in a 'detail' in a text box, hit search, and then have the page return back and show all the other details along that row in the database. For example, the database contains a series of rows with peoples names, addresses, telephone numbers and date of birth. The only required box on the web page would be 'name'. The user enters a name in the box, clicks on search, and then the page displays that users address, telephone number, etc.

I would appreciate any help that anyone has to offer, and if anyone can tell me what I need to do this, that would be a bonus too!!!

Many thanks

Darren

 

[goBoating]

Hello Darren,
I would suggest that you use the Perl DBI/DBD approach. You can setup the Access DB as an ODBC data source on your server ( I assume you are using a WinOS web server since you are trying to do this with Access), and use the DBI/DBD modules to hit that data source.

Take a look a the very recent thread in this forum, thread452-58871.

'hope this helps.


keep the rudder amid ship and beware the odd typo

 

[shukui]

I think both Active Server Page (ASP) and ColdFusion will do the trick. Please consult these two forums.