Results 1 to 5 of 5
  1. #1
    Join Date
    Oct 2003
    Posts
    5

    Question Unanswered: user level password problem

    I recently put user level passwords on a database where I had to do a "join" to repair the security on it. I designed the database in MS Access 2000 so I am the owner and I have admin rights. Now I am prompted to enter this password when I open ANY database. Does anyone know how to fix this?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Yeah ... You set the user password in the MDW file and as such on THAT MACHINE every access DB will require a password for that userid.

  3. #3
    Join Date
    Oct 2003
    Location
    Roanoke, Va
    Posts
    445

    Smile

    Originally posted by M Owen
    Yeah ... You set the user password in the MDW file and as such on THAT MACHINE every access DB will require a password for that userid.
    Kinda frusterating huh ?!

    Gregg

  4. #4
    Join Date
    Oct 2003
    Posts
    5

    how do I fix this?

    Originally posted by M Owen
    Yeah ... You set the user password in the MDW file and as such on THAT MACHINE every access DB will require a password for that userid.
    Do you know how to fix this problem...can I undo this join? My intention was to connect the password to a particular database. That was fixed when I did the join...except I created this problem.

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    I think that unsetting the password for the user should do the trick.

Posting Permissions

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