ACCESS 2007

Copper Contributor

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

3 Replies
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.

@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

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.