MSQuery on a secure database

Posted on 2004-11-09
Medium Priority
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

Accepted Solution

TriggerHappy earned 2000 total points
ID: 12535770
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;"

Author Comment

ID: 12535988
Thanks for the quick response!

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month14 days, 12 hours left to enroll

840 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