How to connect to MS Access with out using DSN

Posted on 2004-10-24
Last Modified: 2010-03-31
How to connect to MS Access with out using DSN ? i.e. with file path only and a username and password
Question by:armoghan
    LVL 92

    Accepted Solution

    connect = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=C:/mydb.mdb";
    LVL 18

    Author Comment

    I saw your answer before but I was unable to find it using the search and knew that you will give answer sooner than me searching for it :))))

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    Title # Comments Views Activity
    zeroFront challenge 7 48
    Enhanced For loop vs ForEach Loop 4 28
    powerN  challenge 3 22
    endX challenge 2 20
    Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
    Introduction This article is the second of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers the basic installation and configuration of the test automation tools used by…
    Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
    Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …

    857 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now