Results 1 to 9 of 9
  1. #1
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Password Confusion (2007)

    I recently split my database (maybe prematurely) and I password protected my backend which has now made any forms past the switchboard inaccessbile. i didn't want to password the front-end, i just wanted to prevent tampering with the back end. what am i doing wrong?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

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

    Re: Password Confusion (2007)

    You'll have to re-link the linked tables in the frontend, using Tools | Database Utilities | Linked Table Manager. You'll be asked to provide the password once. (At least, that's how it worked in older versions)

  3. #3
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Confusion (2007)

    i selected them all and pressed OK to re-link them and it just gives me the same message: not a valid password.

    i guess i can't password protect the backend?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

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

    Re: Password Confusion (2007)

    Yes, you can password-protect a backend database. I think you'll have to delete all linked tables in the frontend, then create them anew. You should be prompted for the password once when you specify the database. After that, you shouldn't be prompted any more.

    If you ever change the password on the backend, you'll have to repeat these steps (delete and recreate the linked tables in the frontend)

  5. #5
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Confusion (2007)

    I deleted all the tables and now the "linked table manager" icon is greyed out and i can't click on it... that can't be good
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

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

    Re: Password Confusion (2007)

    Sorry, I didn't mention this explicitly. Use File | Get External Data | Link Tables to create the links anew.

  7. #7
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Confusion (2007)

    Hooray!

    Now, if i modify the front end and were to hand it out to other employees, they would not experience this issue... is that correct?
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

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

    Re: Password Confusion (2007)

    Once the tables have been successfully linked, it should be OK - for you and for other users.

  9. #9
    5 Star Lounger
    Join Date
    Jul 2004
    Location
    Ohio
    Posts
    629
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Password Confusion (2007)

    Thanks for all the help, Hans.

    for anyone using 2007 all you have to do is go to <img src=/S/ribbon.gif border=0 alt=ribbon width=15 height=15> External Data > Access and choose the option to link to data (not import tables & queries) and you'll be prompted for the password as Hans said.
    <img src=/w3timages/blueline.gif width=33% height=2>
    <big>John</big>

Posting Permissions

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