ODBC Sybase connection in access keeps requesting password!

Posted on 2010-01-06
Last Modified: 2013-11-29

I have a database tables linked to my access through ODBC.  Everything's working fine, but whenever I close and open my access database, and try to access the linked table, it asks me for the linked database's password to re-connect.  Is there any way around this?  I would prefer to save the password so that access can access the database whenever it opens.

One thing I tried was to add a new string value for the password in the ODBC regedit.  This seems to work when testing connecting in control panel as it doesn't prompt me for the password, but access still does! Any help would be great.  Thanks.
Question by:iamnamja
    1 Comment
    LVL 29

    Accepted Solution

    This is how to do it from code:

    Supposably you can also do this using a .map file containing your connection settings, but I have never done this.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    SQL Command Tool comes with APEX under SQL Workshop. It helps us to make changes on the database directly using a graphical user interface. This helps us writing any SQL/ PLSQL queries and execute it on the database and we can create any database ob…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    779 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

    18 Experts available now in Live!

    Get 1:1 Help Now