I am trying to setup a page on my website with a text input box and a command button.
A user will type the serial number of their product and click the button...the result I am looking for is a message telling them if their product is in warranty, out of warranty or not in our system.
I have an Access database with a table called "Warranty_Test" with a table called "Products". The table has (4) fields, SerialNumber (primary key), ModelNumber, ModelName and WarrantyDate.
So I would like to query this table from our website, check the warranty date of the serial number and provide a message based on the results.
Does anyone have any suggestions how to get my website to talk to the database? And secondly, what is the best method of querying the database.