can not debug access project code

[David]

Hi,

Please help me with this problem.

I am working on Access Data Project. It behaves weird. Sometimes an event
(such as command1_click) can not be triggered by clicking the button.
Sometimes when I set an breakpoint in the vba code, access runs without stop
at the breakpoint. There is no error message at all.

Thanks

David

 

[Allen Browne]

Hi David.

This tends to happen when the project is partially corrupt. A decompile may
fix the problem.

To decompile, make a copy of the database, and enter something like this at
the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

If that does not solve the problem, you can rebuild the database quite
quickly by following the 6 steps under the first symptom in this article:
http://members.iinet.net.au/~allenbrowne/ser-47.html

 

[David]

Hi, Allen

Thank you very much for the reply. The decompile approach doesn't work. I
created a new project. The problem has been solved.


David