How to create an .ade from an .adp How to create an .ade from an .adp To create an .ade, open the source .adp file with MS Access. You must use Access 2000 for TRAVERSE 10.0 or 10.1 or Access 2003 for versions 10.2 and 10.5. Verify that the reference to the library file is correct. To verify this click on the Modules button on the left hand side of the .adp. Highlight a Module and then click on Design. If you do not see any modules you may need to go to Tools – Options in Access and verify the options to view Hidden and System objects are checked. May 5, 2007 1 How to create an .ade from an .adp The code screen should show after clicking on Design. Go to Tools and click References. The References screen appears. Highlight the TravLib reference and verify the Location is the correct path to the Library file. If it is not correct, or missing, uncheck the box and use the Browse button to locate the correct TravLib file. By default it should be located in the local TRAVERSE directory. You can also copy May 5, 2007 2 How to create an .ade from an .adp one in to where you want it, but you must delete it after compiling to avoid duplicate library references between the .ade and the TRAVERSE.adp file in the client directory. Click OK to save the reference settings. Go to Debug and choose Compile TravXX. If the Debug goes through without error, the .adp should be able to be converted to an .ade. If you do get errors during the debug, then you may have coding or other issues within the .adp source code. Once the Debug process goes through without error, close the Visual Basic Code screen to return to the .adp file. Prior to creating the .ade you must first set a valid connection. To do this, go to File – Connection. May 5, 2007 3 How to create an .ade from an .adp Select Connection. The Data Link Properties screen comes up. Enter the server name, login information and database information. To prevent users from constantly having to login to the server when going into a specific application make sure to check the Allow saving password option. Click on Test Connection. If connection is successful, click OK. The save password prompt may come up. May 5, 2007 4 How to create an .ade from an .adp Click on Save Password to return to the .adp. Go to Tools - Database Utilities - Make .ade file The Save ADE As screen will show. May 5, 2007 5 How to create an .ade from an .adp Browse to the directory that you want to create the .ade in. You can choose any directory, including the TRAVERSE client directory. If you choose to save it in the client directory, it will replace the one that is already there. Notes and Troubleshooting If you do not have a TravLibXx.mde on the machine that has source code, you will need to copy it into the directory where you are creating your .ade’s. Once you have created your new .ade’s, you should then delete or rename the library file from that directory so TRAVERSE does not think there are multiple library files. If you get a message that the application is not installed after creating a new .ade and going into that application, it means that there was not a connection set to the .adp when the .ade was created. If you get a message that the open connection failed when trying to go into the application that you created a new .ade for, it is most likely caused by a duplicate library file. Open the source code in Access and check the references for the TravLib, if it is referencing something other than the TRAVERSE client directory library file, change to the reference to that Library file or delete or rename the one it is referencing after closing the .adp. May 5, 2007 6