How do I use AJAX to read/write to/from an Access database?

Question

User-1844653115 posted

Color me "extraordinarily frustrated"

I have a simple Access database, sitting on a server called http://www.server.com, called database.mdb. Within it is a table called "table" that has two alphanumeric fields, called "address" and "state".

I have a simple HTML page with a simple select/option statement with a unique value for each option and with a simple Onchange function handler.

I want to be able to open the database retrieve the database record corresponding to the value, dissect the database record into its various fields and then be able to display on the HTML the address and state.

It sounds like it *should* be very easy. But I'm not having any luck. Could someone help me out and, even better, give me an illustrative example?

Thank you.

Ross

Answer 1

User-821857111 posted

You need server-side code to read from and to the database. Are you developing a Web Forms, MVC or Web Pages site?

Answer 2

User-1844653115 posted

Just a simple website, read access to 1-3 tables and write access to 1-3 other tables. Via Dreamweaver CS5 when possible.

Answer 3

User-821857111 posted

As I said, you need server side code to be able to connect to a database and read and write data. This forum isn't the right place to teach anyone how to get started with that from scratch, so you should first choose which server-side framework you want to use (ASP.NET, PHP) and then start learning how to use it. If you choose ASP.NET, I recommend the Web Pages option. It's very similar to PHP, although Dreamweaver doesn't support it. If you are wedded to Dreamweaver, try PHP.