Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Jan 2003
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    78
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Remove Security from Access database (Access2000)

    After converting and Access2 database to Access2000, I am having heaps of problems with the security. Is there a way to remove all the security from the database (that is, change the owner of all the objects back to admin)?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Remove Security from Access database (Access2000)

    It depends on how secured the Access 2 database was. If it was fully secured it is a major challenge. If not completely secured, the simplest way is to simply import all the objects into a new database created using the admin user. Security is one of those things that seems to really challenge developers - you might find our User Security Tutorial of use - in addition it references an excellent more detailed document at http://www.geocities.com/jacksonmacd...sSecurity.html that was created by one of our loungers, <!profile=jacksonmacd>jacksonmacd<!/profile>.
    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
  •