Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Security and Displays (Access 2K)

    1. I created a database that has the tables in a network share (MyDataBase_BE.MDB) and the forms, queries, etc., in my C drive (MyDataBase.MDB). I've noticed that the password function works when I open the database using the file in my local drive (MyDataBase.MDB). However, when I open the file in the network share (MyDataBase_BE.MDB) no password is requested. How can I solve this problem?
    2. I have a two-character text field in a form that I want to remain locked when it has text in it. However, I want to be able to enter text when I create a new record. Also, I want the entered text to be in caps no matter what I enter. How do I set the properties for this?
    Thanks in advance for your usual assistance!

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Security and Displays (Access 2K)

    1. Set the password in the backend database too (Tools | Security | Set Database Password...) You will then have to relink all the tables in the front end (Tools | Database Utilities | Linked Table Manager, click Select All and Always prompt for new location, then OK.)

    2. Put the following code in the On Current event of the form:

    Private Sub Form_Current()
    Me.txtSomething.Locked = Not IsNull(Me.txtSomething)
    End Sub

    where txtSomething is the name of the text box. And put the following code in the After Update event of the text box:

    Private Sub txtSomething_AfterUpdate()
    Me.txtSomething = UCase(Me.txtSomething)
    End Sub

    (the user can enter lower case letters, but they will be converted to upper case as soon as the user tabs or clicks out of the text box)

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Security and Displays (Access 2K)

    Hi Hans,
    I tried the method you supplied to Q1. When I run Linked Table Manager, and connect to the Database_BE to refresh the links, it says, "Not a valid password!" It does not even succeed if I have the BE open??
    Regards,
    Rudi

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Security and Displays (Access 2K)

    Try deleting all the table links then, and recreating them from scratch. You should be prompted for the password once.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Security and Displays (Access 2K)

    Thanx.
    Regards,
    Rudi

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security and Displays (Access 2K)

    How do I delete the table links?

  7. #7
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security and Displays (Access 2K)

    Select the link in the database window and press delete.
    Francois

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Security and Displays (Access 2K)

    My thanks to HansV and Francois. Everything worked out allright!

Posting Permissions

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