Javier I would leave the SATTACHED table and only issue the SCONNECT when the user connects to the database. If everyone is using the same ODBC driver and System DSN Name you should be ok.
Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Javier Valencia Sent: Tuesday, March 22, 2011 2:08 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Collecting data from an Access DB One of my clients has updated its Fuel Managements System. The system collects, among other things, odometer and hour meter every time the vehicle is fueled and also every time the vehicle drives through the gate. The most current information is kept in "vehicle" table in an Access database. The R:Base based Fleet Management System collects fuel transaction and meter information every night at midnight from a downloaded file generated by the Fuel Management System. Now, the client wants to be able to see the most recent information any time a vehicle comes in for servicing or any time the information is needed for other reason. Right now, the procedure to get the most recent odometer and meter information is: SCONNECT SATTACH vehicle table Select the information from the SATTACHED table SDETACH vehicle table SDISCONNECT The query will be run dozens of times during the day from several workstations. My questions are: Should I run the procedure outlined above every time? Since the connection is global, should I SCONNECT and SATTACH once, and leave the connection on, and have users run the SELECT query on the attached table when needed? Are there issues leaving the connection on permanently? Should I SCONNECT AND SATTACH when the first user logs into the system and SDETACH AND SDISCONNECT when the last user exist the system? Any advice, suggestion and words of wisdom will be appreciated. Javier, Javier Valencia, PE 913-829-0888 Office 913-915-3137 Cell 913-649-2904 Fax [email protected] --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
