Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2012
    Posts
    70

    [VB] Username & Password an Access Database

    I am doing some coursework which revolves around a database, I have pretty much everything done but I have to password protect the access database (For some reason, the built-in password protection of access is not allowed even though it protects the DB far better than VB) and also have to use VB code somewhere in it - I thought I would kill two birds with one stone by linking the two.



    The problem is that I know nothing of VB whatsoever. Although I do some Java programming so have used languages before.



    I just want a single username and password for the database (I don't need different users). I need the code to have pretty much this procedure:

    1. Is username ***** and password *****?
    2. If yes, go to form *****
    3. If no, print message "Invalid"



    How do I go about doing this?

  2. #2
    Join Date
    Oct 2012
    Posts
    11
    Save the database as an .mdb then use access's built in security.

  3. #3
    Join Date
    Oct 2012
    Posts
    11
    Check this link out to show you where the security is in access 2007 - 2010

    Where is Security feature in Access 2007, 2010 and 2013

  4. #4
    Join Date
    Aug 2012
    Posts
    70
    Already explained that I can't use that:

    Quote Originally Posted by kkid View Post
    the built-in password protection of access is not allowed even though it protects the DB far better than VB

  5. #5
    Join Date
    Oct 2012
    Posts
    11
    Can you explain why you can not use the built in?

  6. #6
    Join Date
    Aug 2012
    Posts
    70
    The database is for coursework and the exam board won't allow it, they want VB only.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •