Access database decompile; getting ready to release for production

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?
VirtualKansasAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
<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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
VirtualKansasAuthor Commented:
Fast, thank you.  Have a link that IU can study a little more for planning the step by step?  regards...
0
Rey Obrero (Capricorn1)Commented:
0
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.

Jim.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.