Results 1 to 2 of 2
  1. #1
    dlangschied is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2022
    Posts
    1

    Upgrade 2003 db to 2016 db with security intact.

    I tried to find a solution in the forum, but was not able to do so.



    I have a 2003 Access database with security enabled using a system.mda file. This is an upgrade from Access '97.
    There were some issues during the upgrade and there will be more getting up to 2016, for sure.
    My biggest desire is to keep the forms and reports intact.
    It is for that reason that I have been confronted by a major problem in upgrading from 2003 to 2016. And that is security.
    The upgrade worked, no problem. The problem is that I get permission errors when I try to open forms and reports.

    I cannot figure out how to add the security from the previous version to be able to open these objects.

    Your help is greatly appreciated.

  2. #2
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,100
    The old ULS workgroup security has been deprecated in the newer versions of Access. So you need to remove it before you import all objects in a new 2016 file.

    https://documentation.help/MS-Office...lSecurityS.htm
    https://www.access-programmers.co.uk...curity.159640/

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Error exporting to Excel after 2016 upgrade
    By scotiwis in forum Access
    Replies: 2
    Last Post: 11-23-2017, 01:29 AM
  2. cant open database after 2016 upgrade
    By BobW2961 in forum Access
    Replies: 1
    Last Post: 07-24-2017, 07:30 AM
  3. Upgrade accde from 2013 to 2016
    By aldol in forum Access
    Replies: 1
    Last Post: 03-25-2017, 04:19 AM
  4. Replies: 3
    Last Post: 08-17-2016, 08:26 AM
  5. Upgrade database from 2003 to 2010
    By magua in forum Access
    Replies: 1
    Last Post: 06-06-2012, 01:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums