Sharon If I understand your posting correctly: 1. In EEP you cant DISCONNECT OR CONNECT since the form you are running it from is the current open DB. 2. If you need the function in the EEP you can use EXITFORM to close the forma and in the commandfile that originally started the form you can control the opening of a different DB. 3. SCONNECT and SATTACH works! But there are limitations to what you can achieve. I am however still figuring the possibilities and realize that there are different limitations when run R:BASE Dos and Win version not to mention ODBC connect foreign datasources. But again basically it works. 4. A combination of above methods is what I come up to in multiple DB scenario.
Feel free to ask more! Gunnar Ekblad -----Ursprungligt meddelande----- Fr�n: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] F�r Sharon Lima Skickat: den 20 augusti 2004 16:06 Till: RBG7-L Mailing List �mne: [RBG7-L] - Multiple Databases in One Directory Hi All, I am back to work after a long trip around the country and needing help already. It old version I was able to use CONN <otherdb> from within my program. Now in 7.1, I am getting the following error message: Illegal command in Entry/Exit Procedure. Two databases reside in the same directory. The main database is almost always in use. However sometimes the user needs to look into the secondary database for archived data. I think using SATTACH or SCONNECT would be better than disconnecting from the main database in some cases, but I am not getting these commands to work. However, there are cases where I need to be connected to the secondary database only, such as to load in a new form. How do I now get into that secondary database from within my codelocked application? Thanks for help. Sharon Lima
