Help very much appreciated - Access and the web

[cybernetuk]

Hi

I haven't has too much involvement with Access and web stuff for some years but was asked for help with the following. Can someone point me in the right direction to the quickest and simplest soloution! Much appreciated!
----
I have a website, with a booking form on it. I also have a ms access database with the same form names on it. I want to link the website form and the ms access database together. So that when a customer goes onto the website they fill the booking form out with their information, it then gets sent to the database, the database it searched to see if the booking is available if it is then a confirmation message will be displayed, however if it isnt then the customer will be required to enter a different date/or time.

 

[mcclunyboy]

haven't done this myself but hopefully these links are useful:

http://www.4guysfromrolla.com/webtech/042599-1.shtml

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

http://www.webwiz.co.uk/kb/asp-tutorials/connecting-to-an-access-database.htm

 

[cybernetuk]

Thanks for that.
If the HTML they were using was just a simple MAILTO form - is there anything that would simply drag out the data from the email and put into into the database?

 

[mcclunyboy]

Thanks for that.
If the HTML they were using was just a simple MAILTO form - is there anything that would simply drag out the data from the email and put into into the database?

which version of access are you using?

MS Access 2007 (and probably 2010 although I can't confirm) offered a Data Collection tool for use with emails.
http://office.microsoft.com/en-us/access-help/collect-data-by-using-e-mail-messages-HA010015427.aspx

Is that what you mean?

 

[cybernetuk]

Ah yeah that looks like it would work - Im using 2010 so will have a look at this.
Thanks!

 

[mcclunyboy]

if you need better integration into a website, ask here again...i am relatively inexperienced with that and there maybe an easy way...