Jim Lawrence (AccessD)
accessd at shaw.ca
Wed Oct 29 09:49:13 CST 2003
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