Dawn, Good thought. However I have battled with this database because the settings will not allow sconnect and sattach. The owner of the database is adamant that we
not touch those settings so I am stuck with them. Jan -----Original Message----- From: "Dawn Hast" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 28 Aug 2008 16:57:47 +0000 Subject: [RBASE-L] - Re: Second connection Can you sconnect to the second db and sattach the necessary tables to update? -------------- Original message from "jan johansen" <[EMAIL PROTECTED]>: -------------- Group, I have a process that archives from one database to the another. I have a step that checks for the number of connections before I start the process. However the process can take 10-15 minutes and it never fails, someone will connect to either of the databases in the middle of the processes. Although I use SET MULTI OFF, when I disconnect from database 1 and connect to database 2, database 1 becomes available for connections because I am now in database 2. Anyone have any slick tricks to open a second connection with code so that with SET MULTI OFF I have the only connections allowed to the database and then shut down both connections after I am done? Jan
