Tool to identify Access Logic

[DKL01]

Hello All:

We got an application in MS access. I was wondering if there is any tool exists which provides me documentation of logic by going through each line in MS Access code.

I really appreciate your help.

Thanks

 

[tombirch]

You can use the Access visual basic editor buid into access to go through the code. You can make the application run a line at a time by just clicking next to the line where you want to start checking. When that line is called in Access the code window will pop up with the line highlighted. By pressing F8 you go to the next line and so on. To get help just press click on the object and press F1.
The values of variables can be checked by using the locals windows, watch window or simply by placing you mouse over the variable.
Look for more information in access basic help by searching for 'debug'.

 

[MichaelRed]

Dilip,

Tom's response is a good approach for those who have some understanding of both database and programming in geeneral or who have some time to 'dig in' and learn. If you just need to get through some particular issue in a hurry, it be more efficient to post some specific questions, or if it is a BIG problem, take a class or two in Ms. Access and/or database.


MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over