Access database decompile; getting ready to release for production

Posted on 2013-08-27
Medium Priority
Last Modified: 2013-08-27
Recently read an article describing the following as a finishing touches for an Access database to go to production.
1) Create a new database and import all objects from source database
2) Restart access using /decompile option while holding shift key
   a) Restart access normally while holding shift key
     i) Close after the database windows is displayed
3) Restart access normally while holding the shift key
4) Compile the database
5) Compact and repair the database

Question is; is this a "good idea"?  If so, will this work on a split database, or should it be rejoined before attempting?
Question by:VirtualKansas
  • 2
LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 39442196
<Question is; is this a "good idea"?  > Yes

<If so, will this work on a split database, > Yes

 or should it be rejoined before attempting?  - No Need since you will only distribute/install the FE

- it is also a good practice that you run a compact and repair to the BE

Author Closing Comment

ID: 39442222
Fast, thank you.  Have a link that IU can study a little more for planning the step by step?  regards...
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39442248
LVL 59
ID: 39442251
Pretty much a good idea, but /decompile is an undocumented switch.  While it has worked thousands of times, it's also failed and messed up a DB in some cases.

So make sure you have a backup.

Also, if your importing everything into a new DB, you should not need it.  When you import, only source code gets pulled.

What /decompile does is invalidate compiled p-code.


Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

A Case Study of using the Windows API to provide RS232 communications capability in Access without the use of Active-X controls.
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question