Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

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.
0
Bill Warren
Asked:
Bill Warren
  • 2
1 Solution
 
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
 
Bill WarrenIT 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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now