MSQuery on a secure database

Posted on 2004-11-09
Last Modified: 2008-03-06
Hello all,

I recently applied the User Level Security Wizard to assign group permissions on a database.. everything works fine, exept that I had some external queries that pulled data to Excel through MSQuery. The query tries to access the database WITHOUT asking for a login or password then says I do not have the required permissions to access the data..

How do I set the query to ask for a login & pw?

Thanks in advance for any tips or workarounds..

Question by:BTognietti
    LVL 9

    Accepted Solution

    If you connect to the database using an odbc connection then you can simply provide your username and password in the connection string.

    "Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=YourUserName;Pwd=YourPassword;"
    LVL 9

    Author Comment

    Thanks for the quick response!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    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

    11 Experts available now in Live!

    Get 1:1 Help Now