By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,470 Members | 1,042 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,470 IT Pros & Developers. It's quick & easy.

Pass Through Query with Custom Login Form

Seth Schrock
Expert 2.5K+
P: 2,949
I've created a pass through query, but I don't want the credentials saved in the connection string. So when I run it, it asks for a password. Is there a way to pass it the credentials from a custom login screen instead of the ugly Microsoft screen that comes up? I guess I could change the connection string at run-time using code, but that seems clunky. I'm hoping for a query.execute, UID="", PWD="" type option, but I can't find anything in a google search.
4 Weeks Ago #1
Share this Question
Share on Google+
2 Replies

Expert Mod 2.5K+
P: 3,385

From what I understand, you "should" be able to have a user login/password form and then generate the Connection String from there. This prevents you from saving passwords and all that security stuff that MS Access isn't good at. it should look something like this:

Expand|Select|Wrap|Line Numbers
  1. qdf.Connent = "ODBC;DRIVER={Microsoft ODBC for Oracle};UID=abcdef;PWD=12345678;SERVER=serverabc123;"
This is a bit outside my wheelhouse, but this may get you started in creating that string.....
4 Weeks Ago #2

Seth Schrock
Expert 2.5K+
P: 2,949
Well, I was hoping for a different way, but I'll probably just have to go that route.
4 Weeks Ago #3

Post your reply

Sign in to post your reply or Sign up for a free account.