SQl 2005 Access 20033 ADP Security - Require Username Password

I have an ADP file that I have setup using NT Security. Is there any possible way to insert  a prompt for new login to the database. There must be a way to code this or something.
Bill WarrenIT ManagerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Bill WarrenConnect With a Mentor IT ManagerAuthor Commented:
I figured out a way... Created batch file #1 that ran another batch file #2 that required a pasword which I specify in the #2 batch file after authenticating correctly it starts the adp file. Then I converted the batch file #1 to an exe so it is not easily traceable back to the #2 batch file. I can fairly easily manage the passwords in the second batch file. Which is all I was looking for. Thanks though
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
If you mean the server is setup to allow for Windows Authentication, then no, not really ... you can set it either Mixed Mode or Server Authentication, at which point you'd have to log into the server.
0
 
Bill WarrenIT ManagerAuthor Commented:
I have to keep the windows authentication but I want to make the user have to use a username and password to open the Access interface. There's no way to acheive this?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.