Forum Discussion

Alain_VIRICEL's avatar
Alain_VIRICEL
Copper Contributor
Nov 01, 2020

ACCESS 2007

Bonjour ,

J'ai une base de données fonctionnant sous access 2007 avec un fichier .mdw associé

J'aimerai utiliser cette base sous access 2016 mais lorsque j' ouvre la base le message suivant apparait 

Vous n'avez pas l'autirisation d'exécuter "FORM_GENERAL" vous devez avoir l'autorisation d'accès ouvrir/exécuter

Cela provient surement du fichier .mdw avec les droits associés

Comment puis je résoudre ce problème

Merci de votre aide

  • You have too launch the database using the property command line switches (by creating a shortcut) that include reference to the new. Below is a template of what the shortcut would look like

    "C:\Program Files\Microsoft Office\Office16\MSACCESS.EXE" "C:\...\YourDbName.mdb" /WRKGRP "C:\...\YourSecurityDbName.mdw"

    You have to adapt the above sample to suit your setup, msaccess location, db and MDW file location and names.
    • Alain_VIRICEL's avatar
      Alain_VIRICEL
      Copper Contributor

      Daniel_Pineault 

      Hello , I launch ACCESS with a similar link but the error message when opening is as follows: Cannot open a database created with an earlier version of your application

      • Daniel_Pineault's avatar
        Daniel_Pineault
        MVP
        That's a completely different issue.

        The newer versions of Access only support the latest (jet 4) versions of mdbs. So older 2.0, '97, 2000 mdbs are no longer supported (they are 30+years old afterall). The solution is that you must use an intermediary version of Access to upgrade the file format. So you need to use Access 2003 to upgrade your mdb to the most recent file format, then it will work.

        That said, you truly should be looking to use 2007, 2010 to upgrade to accdb, but this means no more ULS (MDW security). There is no guarantee that Microsoft will continue supporting mdbs for much longer.

Resources