Using the /decompile switch in Access 97

SERVTRKR
SERVTRKR used Ask the Experts™
on
We have a relatively large database using Access 97 (Large meaning several hundred tables and queries) and frequently have to use the /decompile switch when modifying the code to get around the "General Fault Protection Error". Without this 'little known' feature, we would have been dead in the water long ago.

We are now considering migrating the program to Access 2002, but that feature doesn't exists. Does anyone know if that's because it's no longer needed in 2002 (Microsoft did a better job) or if they simply left it out?

Our concern is if we upgrade and run into the same "General Fault Protection Error" which throws you out of Access, there is no recovery.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
As far as my experince the feature still exists in Access2002?

Say I I have a Access2002 file,

1 . open a module and take a Compile & save all modules.
2. Close the file and re-open it the comple & save all modules are disbaled->the code is in a compiled state
3. The run a shortcut:
"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE"  D:\VISMADRILLDOWN\Visma2002.MDB /DECOMPILE

Whan I open the Mdb again the "Compile & save all modules" are enabeld so I can compile the program once more..

So the /DECOMPILE switch is still there?

or..?

perove

Author

Commented:
I was getting an "Unreconized command" error so I assumed it was no longer supported. I'll try again and let you know.

Thanks

Commented:

No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
 - PAQ'd and pts removed
Please leave any comments here within the
next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

Nic;o)
Commented:
Finalized as proposed

modulo

Community Support Moderator
Experts Exchange

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial