[dba-SQLServer]Linking to Local Table

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.


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com]On Behalf Of David
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?


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

More information about the dba-SQLServer mailing list