[dba-SQLServer]Linking to Local Table

Thanks for the suggestion Jim but ADP's don't have local tables - they are 
all attached.

David

At 29/10/2003, you wrote:
>Hi David:
>
>You can do this by storing the values in a table on the FE database. If the
>FE is central the file name can be suffixed by the caller station's id
>or/and username.
>
>Jim
>
>-----Original Message-----
>From: dba-sqlserver-bounces at databaseadvisors.com
>[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of David
>Emerson
>Sent: Tuesday, October 28, 2003 7:47 PM
>To: dba-SQLServer at databaseadvisors.com
>Subject: [dba-SQLServer]Linking to Local Table
>
>
>AXP adp, SQL2000
>
>Currently I have a table of customer primary keys that is filled in from
>the contents of a list box.  This table is then used to link to other
>tables as a filter for processing client records.
>
>Because the BE is in SQL, the same table is accessed by all
>users.  However, a user often wants the selection to be maintained between
>sessions (ie if they return to the selection screen the next day they want
>their previous day's selection still showing.)  This excludes temporary
>tables (I think) because the users close the program over night.
>
>If there was a table stored on the local drives then each user could have
>their own list of customers.
>
>What I am unsure of is how I can a) link to the local database to fill it
>up with the selections, and b) how I can reference that table within SQL
>sprocs which use sql tables.
>
>Any pointers/key words to look up?
>
>Regards
>
>David Emerson
>Dalyn Software Ltd
>25 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
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com

Regards

David Emerson
Dalyn Software Ltd
25 Cunliffe St, Johnsonville
Wellington, New Zealand
Ph/Fax (877) 456-1205