can not debug access project code

  • Thread starter Thread starter David
  • Start date Start date
D

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
 
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
 
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
 
Back
Top