That is the direction I was thinking. Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax [email protected]
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bob Thompson Sent: Tuesday, March 22, 2011 7:14 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Collecting data from an Access DB The attached table definition is global, but each session still has to connect to thier ODBC source each time it starts up. Each time a session connects to the ODBC database, it holds file handles on it open. This may or may not cause problems in the long term. My practice is to SConnect, retrieve data, then SDisconnect, "on the fly" so to speak. No need to have several work stations acessing the file(s) for long periods of time when you need them only for seconds. I believe it reduces the chance for problems and theoretically should use less resources. Bob Thompson LaPorte, IN 219-363-7441 Sent from my iPod On Mar 22, 2011, at 1:08 AM, "Javier Valencia" <[email protected] > wrote:
