Mike and Doris Manning
mikedorism at ntelos.net
Wed Feb 12 14:57:27 CST 2003
An ini file stored on that machine. An XML file stored on that machine. A small MDB stored on that machine that you interact with via OLEDB. A separate SQL Database to hold the info for each individual machine. There are tons of work arounds. My personal preference has been to create a UserPref database within SQL to store the info because then I don't have to worry about something on the individual machine changing. Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: dba-sqlserver-admin at databaseadvisors.com [mailto:dba-sqlserver-admin at databaseadvisors.com] On Behalf Of David Emerson Sent: Wednesday, February 12, 2003 03:35 PM To: dba-SQLServer at databaseadvisors.com Subject: [dba-SQLServer]Local Tables in an ADP I am working on an application which was upgraded from an A97 FE/BE to and AXP ADP/SQL2K. In the previous version we had some local tables in the FE that held information specific to that FE (and there were several FE's). For example when a new client was entered then their account number was generated partly from a number held in the local table. Different FE's had different number ranges for new accounts. My understanding is that there are no local tables in an ADP. What is the way around storing information on each machine that is specific to that machine? Regards David Emerson DALYN Software Ltd 25b Cunliffe St, Johnsonville Wellington, New Zealand Ph/Fax (877) 456-1205 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com