Results 1 to 5 of 5
  1. #1
    clebergyn is offline Advanced Beginner
    Windows 7 32bit Access 2003
    Join Date
    Dec 2012
    Location
    Brazil
    Posts
    48

    How to put a password only in the database?


    How to put a password only in the database? has as at the start, put the general access password automatically through the "autoexec"? Anyone have any examples?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,525
    menu: Tools, security, set db password.

    or are you talking about somthing else?

  3. #3
    clebergyn is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2012
    Location
    Brazil
    Posts
    48
    I need through VBA code. Is there a way to put passwords only tables?

  4. #4
    clebergyn is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2012
    Location
    Brazil
    Posts
    48
    Quote Originally Posted by ranman256 View Post
    menu: Tools, security, set db password.

    or are you talking about somthing else?

    That's right, but I want to use the "front-end" with no password and use the "back end" with the password. If you have no other way, I want to do through "VBA"

  5. #5
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    The best way is to use encryption via the options. There may be a way to do this via VBA but, I do not know how. It seems as though it would be a lot easier to click the options.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Password Protecting the backend database
    By data808 in forum Security
    Replies: 7
    Last Post: 02-24-2014, 10:45 AM
  2. Replies: 2
    Last Post: 09-21-2012, 05:12 PM
  3. New database asking Name and Password:
    By teja in forum Database Design
    Replies: 18
    Last Post: 02-29-2012, 02:43 AM
  4. Replies: 2
    Last Post: 05-23-2011, 10:36 AM
  5. Requested Password in new database access
    By baldo10 in forum Access
    Replies: 3
    Last Post: 09-07-2010, 04:23 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums