[dba-SQLServer]Local Tables in an ADP

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





More information about the dba-SQLServer mailing list