PDA

View Full Version : Reading an ACCESS file from JavaScript



austenr
03-03-2005, 02:51 PM
:dunno Does anyone know a way to read an ACCESS file from a Javascript menu and return a value? What I am looking to do is to have the ability to select a name from a dropdown box in JScript and return a popup Box with the following information:

Salesman Phone Ext. Email:

Salesman Backup Phone Ext. Email:

Accounts

xyz company
acme co
etc.

Anyone have any ideas? Thanks in advance for your help.

Paleo
03-04-2005, 04:55 PM
There is no way you can access a database through JavaScript running in a web page (html) because it runs on the client and the database is on the server.

If you are talking about JavaScript running on a web page (asp) then yes, you may access that database by using this connection strings:

Standard security:

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;User Id=admin;Password=;"



Workgroup (system database):
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:System Database=system.mdw;"


With password:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb;Jet OLEDB:Database Password=MyDbPassword;"


Is it an asp file? Do you need the connection code also?