MSQuery on a secure database
Posted on 2004-11-09
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..