Solved

Program to get LogIn and Password for Access 97

Posted on 1998-09-17
6
139 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
Comment Utility
Tell me your email so I can send my VB program to you.
0
 
LVL 5

Expert Comment

by:chewhoung
Comment Utility
My email:
chewhoung@yahoo.com
0
 
LVL 5

Expert Comment

by:chewhoung
Comment Utility
Email Sent.
0
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 

Author Comment

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

Expert Comment

by:chewhoung
Comment Utility
Email Sent.
0
 

Author Comment

by:juniorprog
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
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…

744 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now