A friend asked me to help him with his company's access form. The problem is I've never worked with .adp and .ade files. So I have some basic questions.
1. I know that I need to make changes to the original .adp file and then save it as an .ade file. But when I do that, does it compile the code and check for any errors during this process?
2. Once I save it as an .ade file how do I make sure the end users throughout the network have the copy with the latest changes? Is there some sort of script? Or if they all have shortcuts to this .ade file they will automatically see the changes?
3. How should I work on code and test before applying these changes to the LIVE system? Should I make a copy of the .adp file and name it something else (say MyTest.adp) and then save the .ade file as MyTest.ade and then try opening it on an end user workstation to see if the changes are ok?
Thank you in advance!