Combining MS Access with a Web Page 1

[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

 

[NikP]

Darren..you are in the correct place...
you can do what needs to be done through asp....
If you are not familiar with ASP or HTML you learn the basics..and from then on in connecting to an Access dB is simple...

The basic concepts would be ....

an html page with a form which has a text box and a submit button...

the value of the submit button can be used to build a query on your access dB and results can then be displayed...

I know this is very simple but there are a few good sites with tutorial about where this type of function is fully explained...

good luck

 

[Darrenb]

Many thanks for the info. I will have a look on the web and see if I can find any tutorials on ASP. Anyone know of any?

Darren

 

[RobV]

Check

http://www.learnasp.com

for example. They provide a good place to start Yours,

Rob.

 

[TonyU]

Here are a few:
I've been ASP programming form 3 months now and these sites wee very helpful

http://www.stardeveloper.com/asp_tutorial_1.asp

http://www.aspin.com/

http://www.w3schools.com/asp/

--> I found this the best Tony