Solved

Program to get LogIn and Password for Access 97

Posted on 1998-09-17
6
144 Views
Last Modified: 2013-12-05
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
Comment
Question by:juniorprog
  • 4
  • 2
6 Comments
 
LVL 5

Accepted Solution

by:
chewhoung earned 200 total points
ID: 1435450
Tell me your email so I can send my VB program to you.
0
 
LVL 5

Expert Comment

by:chewhoung
ID: 1435451
My email:
chewhoung@yahoo.com
0
 
LVL 5

Expert Comment

by:chewhoung
ID: 1435452
Email Sent.
0
The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

 

Author Comment

by:juniorprog
ID: 1435453
Have sent you, chewhoung, my e-mail on your yahoo site.  Please respond.
Thanks
0
 
LVL 5

Expert Comment

by:chewhoung
ID: 1435454
Email Sent.
0
 

Author Comment

by:juniorprog
ID: 1435455
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

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question