Improve company productivity with a Business Account.Sign Up

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

Program to get LogIn and Password for Access 97

Has anyone made a small program to get from a user their Access password and login and then take this and a coded Access database password to get into Access?  Basically, for security reasons and own personal preference, I want to keep my Access program as an mdb (not convert into an MDE) and put both a database password and security on it (using an MDW).  The Security has been set up successfully, but to prevent a user to bypass this (by holding down the shift key and double-clicking on the mdb in Windows Explorer) I have had to add a database password.  But, this will mean that the user will have to enter in both passwords which results in 2 screens...  So, basically, I was looking to write a small VB program to get the UserName and password from a user - look it up to the specified mdw, then take a coded in database password to open up Access completely.

I hope that this is explanation enough... if not, please let me know.  Also let me know if I should maybe post this question into the Access area instead.
0
juniorprog
Asked:
juniorprog
  • 4
  • 2
1 Solution
 
chewhoungCommented:
Tell me your email so I can send my VB program to you.
0
 
chewhoungCommented:
My email:
chewhoung@yahoo.com
0
 
chewhoungCommented:
Email Sent.
0
Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

 
juniorprogAuthor Commented:
Have sent you, chewhoung, my e-mail on your yahoo site.  Please respond.
Thanks
0
 
chewhoungCommented:
Email Sent.
0
 
juniorprogAuthor Commented:
Your code has given me lots of insight on how VB can use an mdw and I thank you for that.  Unfortunately, I can not rate the answer given as excellent since it did not fully answer my problem of sending a database password.
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

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