Forum Discussion
Alain_VIRICEL
Nov 01, 2020Copper Contributor
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_VIRICELCopper Contributor
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
- 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.