Results 1 to 4 of 4
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Copy DB Permissions (Access 2003/SP3)

    I've got a DB that is displaying symptoms of corruption. Importing all the objects into a new DB is easy. Reconfiguring all the item permissions is a pain. Especially since the documenter is one of the things not functioning in the old db.
    Does anyone have any suggestions (aside from my current idea - open both db's simultaneously (tedious!)) for extracting/copying/reporting on the permissions?

    TIA
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: Copy DB Permissions (Access 2003/SP3)

    The DBUtilities 2000 add-in by Jeff Conrad lets you transfer object permissions. See DaigleNet.

  3. #3
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Copy DB Permissions (Access 2003/SP3)

    Thanks
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Copy DB Permissions (Access 2003/SP3)

    Generated a mysterious error message - but still seems to work quite nicely - I'll be testing the new healthier db over the next couple of days.
    Certainly the couple of weird export and documenting problems I had seem to be resolved.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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