Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Thanked 0 Times in 0 Posts

    One MDW File (Access 2000 SR-1)

    I made the mistake of making several MDW files for my company because there were only a few databases that needed security. Now I want to create a new one with all the employees in there. Is there a way for me to import from a spreadsheet, the person's name? There are over 300 employees.



  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Evergreen, CO, USA
    Thanked 65 Times in 64 Posts

    Re: One MDW File (Access 2000 SR-1)

    Not without lots (and lots) of work. You can manipulate the security model in code, so you could write code to extract all of the user info out of each of the different .MDW files and stick it in a table, spreadsheet or what ever. Then you would have to write code to create new users from that data into the new .MDW file. In addition, if you want to make sure that you can switch to the new .MDW file and have user's inherit the same priviledges they had, you need to make certain that the Personal ID is the same as they had in the old MDW file. The question is, is that worth while as opposed to typing in 300 names?

Posting Permissions

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