jQuery won't talk directly to your Access database. This may be why you've had trouble finding help with that. jQuery sits on the client and your database is on your server. You need a server-side script to open the database and create a dynamic pages (html, xml, or json) with data for the client.
The server-side script langauge choice will depend on what web server you're using and what you know/like, but might be one of php, perl, python, asp (vbscript), asp.net (vb, c#). You should be able to find tutorials online for querying an access database using any one of these (ex. google: asp access database). Basically each script will: 1. Make an adodb or odbc connection to the database file on the same server as the script 2. Run a query against the database to get the data you want, perhaps generated based on querystring parameters to specify the correct table and possibly filter the rows 3. Format that data as html, xml, or json That should get you started. You'll have a server-side script(s) that will handle an http/ajax request, fetch some data, then provide an http response. >From jQuery's point-of-view it's just making requests at urls and getting back results. It doesn't know (or care) what's being done (or how) on the server. - Richard On Jan 25, 2008 3:00 PM, Jesslyn <[EMAIL PROTECTED]> wrote: > > I have been searching for tutorials or examples that allow a website > to pull information from an Access database using jQuery or Ajax. So > far my search has been unsuccessful and there is probably a good > reason for that. > > I'd first like to know if this is even doable and if so are there any > examples/tutorials that could be of any assistance? If this is not > doable, then I'd greatly appreciate any other advice you may have to > offer to help me achieve the overall goal of pulling info from an > Access database into a table displayed online. > > Thank you so much for your time, I greatly appreciate it! > > > -Jesslyn >
