Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    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.

    Thanks

    Paul

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 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?
    Wendell

Posting Permissions

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