{"id":2908,"date":"2016-04-16T11:34:38","date_gmt":"2016-04-16T09:34:38","guid":{"rendered":"http:\/\/www.blue-bears.com\/blog\/?p=2908"},"modified":"2016-04-20T23:45:06","modified_gmt":"2016-04-20T21:45:06","slug":"access-fichier-inexistant","status":"publish","type":"post","link":"http:\/\/www.blue-bears.com\/blog\/?p=2908","title":{"rendered":"Access : Fichier inexistant"},"content":{"rendered":"<ul>\n<li>Gros plantage.<\/li>\n<li>Suite \u00e0 un peu de \u00ab\u00a0m\u00e9nage\u00a0\u00bb dans les modules VBA inutiles alors que la liaison r\u00e9seau \u00e9tait chancelante je me retrouve dans la situation suivante :<\/li>\n<li>Les modules supprim\u00e9s ont disparus du panel ACCESS mais sont toujours l\u00e0 dans le panel VBA : Impossible de les supprimer dans VBA et impossible de les utiliser dans ACCESS.<!--more-->\n<ul>\n<li>La copie de la base g\u00e9n\u00e9r\u00e9 la m\u00eame erreur<\/li>\n<li>De multiple compactage\/r\u00e9paration sont sans effets.<\/li>\n<\/ul>\n<\/li>\n<li>Solution : d\u00e9compilation\/recompilation de la base :\n<ul>\n<li>\u00ab\u00a0path to ACCESS\u00a0\u00bb \u00ab\u00a0Path to Base\u00a0\u00bb \/decompile<\/li>\n<li>Essai sur la copie de la base<\/li>\n<li>\n<pre><code>\"C:\\Program Files\\Microsoft Office\\Office15\\MSACCESS.EXE\" \"N:\\DEGP\\VAL_DE_FRANCE_TRANSACTIONS\\CRM_VDFT\\CRM_VDFT - Copie.accdb\" \/decompile<\/code><\/pre>\n<\/li>\n<li>Message pr\u00e9venant de la suppression de TOUS les modules VBA !!<\/li>\n<li>J&rsquo;accepte et r\u00e9cup\u00e9rerai le code dans la version originale.<\/li>\n<li>Surprise les modules sont encore tous visibles &#8230; mais inaccessibles. Au lieu d&rsquo;en avoir un seul plant\u00e9s &#8230; ils le sont tous.<\/li>\n<li>Compactage et r\u00e9paration de la base.<\/li>\n<li>Sans effet !<\/li>\n<li>Je supprime l&rsquo;appel \u00e0 la fonction du module disparue\u00a0 dans la macro de d\u00e9marrage AutoExec qui est maintenant vide.<\/li>\n<li>Et relance un compactage.<\/li>\n<li>Pas d&rsquo;effet apparent &#8230;. mais je peux supprimer les modules dans le panel ACCESS.<\/li>\n<li>Dans VBA les modules ont tous disparus<\/li>\n<li>Les requ\u00eates s&rsquo;ouvrent bien dans ACCESS et cela confirme ce que je craignais : le travail de la journ\u00e9e d&rsquo;hier est perdu !<\/li>\n<li>Il ne reste plus qu&rsquo;a exporter les modules de la base d&rsquo;origine et les r\u00e9importer dans la base copie &#8230;.<\/li>\n<li>Note pour moi m\u00eame :<\/li>\n<li><span style=\"text-decoration: underline;\"><span style=\"color: #ff0000;\"><strong>NE PAS M\u00c9LANGER le VBA de 2 applis MSFT diff\u00e9rentes !!!<\/strong><\/span><\/span><\/li>\n<\/ul>\n<\/li>\n<li>Le\u00e7on :\n<ul>\n<li>Faire des sauvegardes incr\u00e9mentales de la base !!<\/li>\n<li>Backup_Base.bat\n<pre>set jour=%date:~0,2%\r\nset mois=%date:~3,2%\r\nset annee=%date:~6,4%\r\nset madate=%annee%%mois%%jour% \r\necho %madate%<\/pre>\n<\/li>\n<\/ul>\n<\/li>\n<li>Bblio :\n<ul>\n<li><a href=\"http:\/\/stackoverflow.com\/questions\/3266542\/how-does-one-decompile-and-recompile-a-database-application\">http:\/\/stackoverflow.com\/questions\/3266542\/how-does-one-decompile-and-recompile-a-database-application<\/a><\/li>\n<li><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Gros plantage. Suite \u00e0 un peu de \u00ab\u00a0m\u00e9nage\u00a0\u00bb dans les modules VBA inutiles alors que la liaison r\u00e9seau \u00e9tait chancelante je me [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-2908","post","type-post","status-publish","format-standard","hentry","category-informatique"],"_links":{"self":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2908","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2908"}],"version-history":[{"count":13,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2908\/revisions"}],"predecessor-version":[{"id":2921,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/2908\/revisions\/2921"}],"wp:attachment":[{"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2908"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2908"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.blue-bears.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2908"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}