Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    300

    Red face Unanswered: Problem opening protected database

    I have 5 databases that use linked tables and wanted to password protect all 5 database. Problem is that some of the macros now are not working. I am getting a RUNCODE error and it is locking up. Did I forget to add something to the VB code?

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Chances are that if a database is protected and you're running a macro that accesses a linked table from a protected database, it will have a hissy fit.

    I suggest (quite a long winded)... suggestion 8-)

    - remove all password protection.
    - convert all macros to modules
    - replace the docmd.runmacro commands to call the modules
    - test them all
    - if they all work, delete the macros (not the modules)
    - password protect the VBA code
    - convert the database to an MDE

    It does all depend on why you are wanting the password protection.
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Just had another thought...

    Because it's a case of protection - you'll need to change the DSN properties to include the new passwords on your linked tables.

    Again, this depends how you have set up the linked tables.
    George
    Home | Blog

  4. #4
    Join Date
    Nov 2003
    Posts
    300
    Management wants to have only certain users to have access to certain databases, just because one person got into where they should not have been-----causing problems..

    So, with 50 users, instead of using the Security Wizard.. etc. I figured it was easier to just do passwords. Your first response is understandable but-- a lot of work. The second one makes me wonder if that might be ALL I would have to do just to get this to work..??

  5. #5
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Backup all the databases and then try relinking the tables using your new passwords.
    Might be worth a shot but I am nt sure it will solve all your security issues.
    Perhaps it's time to build your own logon form with a users table
    Users(Username, Password, db1, db2, db3...)
    the db fields could be a simple yes/no which you can reference to give them access to the correct databases (Eg, user1 can only access db 1 and 3 - User1, ***, Yes, No, Yes)
    Or use the access wizardyness.
    George
    Home | Blog

Posting Permissions

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