Consulting

Results 1 to 2 of 2

Thread: Reading an ACCESS file from JavaScript

  1. #1
    Moderator VBAX Master austenr's Avatar
    Joined
    Sep 2004
    Location
    Maine
    Posts
    2,033
    Location

    Reading an ACCESS file from JavaScript

    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.
    Peace of mind is found in some of the strangest places.

  2. #2
    Administrator
    VP-Knowledge Base
    VBAX Master
    Joined
    Jan 2005
    Location
    Porto Alegre - RS - Brasil
    Posts
    1,219
    Location
    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 OLEDBatabase Password=MyDbPassword;"


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

    Carlos Paleo.

    To every problem there is a solution, even if I dont know it, so this posting is provided "AS IS" with no warranties.

    If Debugging is harder than writing a program and your code is as good as you can possibly make
    it, then by definition you're not smart enough to debug it.




    http://www.mugrs.org

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •