Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 2000 Password

    I have an Access 2000 database set up with a frontend that will be kept on the users local drive and linked to tables in the backend that will be located on the server. During the testing phase, I wanted to setup a password to provide basic level security for the backend and for the frontend. However, when I set the password for the backend and then opened the frontend that did not yet have a password, it did not provide me with a box asking for a password but gave me a password error message. How can I have a password that is different for both the backend and for the frontend or is that possible?
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

  2. #2
    Lounger
    Join Date
    Feb 2001
    Location
    TX, USA
    Posts
    34
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000 Password

    you need to provide the back-end password in the connection (link) string for the back-end tables

  3. #3
    3 Star Lounger
    Join Date
    Mar 2001
    Location
    Minneapolis, Minnesota, USA
    Posts
    262
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000 Password

    Or you might try implementing Workgroup level security. Access database passwords are ridiculously easy to crack, a DOS based program and 30 seconds is all that's needed, but a Workgroup implementation should be much more secure.

    Regards,
    <font face="Comic Sans MS"><font color=blue>~Shane</font color=blue></font face=comic>

  4. #4
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Manassas, Virginia, USA
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access 2000 Password

    How do you go about providing a back-end password in the connection (link) string for the back-end tables?
    Judy Jones, Computer Training Specialist
    Manassas, Virginia

Posting Permissions

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