Hi friends…
I got a VBA application(MS Access 2003) that almost already completed and I’ve some maintenance work in that application.. but unfortunately some of the pages are not responding while I open it in a design view… I mean after I open the page in the design view and when I trying to click on any of the control in the page for editing its property or right click on any of the control… the page including the full screen, access tool bar all are not responding. I cant even close that application after opening this type pages… but some other pages in the same application have no problem….
Can u pls help me
I'm not a big fan of cut and paste solutions, but the following outlines steps you might take if you find that you have a problem with corruption in your database. Unresponsive objects such as forms and controls indicates this condition. Make a back up copy of your database before you attempt any of the following.
J
A **DeCompile** may help here ...
But first, if you have not already:
Check for any **Missing References via the VBA Editor>>Tools>>References ....
Then, follow this procedure:
0) **Backup your MDB**
1) Compact and Repair the MDB, as follows:
Hold down the Shift key and open the MDB, then from the menu >>Tools>>Database Utilities>>Compact and Repair ...
2) Execute the Decompile (See example syntax below) >> after which, your database will reopen.
3) Close the mdb
4) Open the mdb and do a Compact and Repair (#1 above).
5) Open the mdb:
a) Right click over a 'blank' area of the database window (container) and select Visual Basic Editor. A new window will open with the title 'Microsoft Visual Basic' ... followed by then name of your MDB.
b) From the VBA Editor Menu at the top of the window:
>>Debug>>Compile
Note ... after the word Compile ...you will see the name of your 'Project' - just an fyi.
6) Close the mdb
7) Compact and Repair one more time.
*** Executing the DeCompile:
Here is an example of the command line syntax (adjust your path and file name accordingly) for executing the
decompile:
Run this from Start>>Run, enter the following command line ...
"C:\Program Files\Microsoft Office\Office\Msaccess.exe" /decompile
"C:\Access2003Clients\AzDoc\Pgrm\AzDocPgrm2K3. mdb"
For more detail on the Decompile subject ... visit the Master on the subject (and other great stuff) Michael Kaplan:
http://www.trigeminal.com/usenet/usenet004.asp?1033