MS Access Query From Web

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 373,936 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,600 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS Access and FileMaker Pro advertiser:

MS Access Query From Web

•

Join Date: Apr 2008

Posts: 1

Reputation: cpiascik is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

cpiascik

Offline

Newbie Poster

MS Access Query From Web

Apr 17th, 2008

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.