David Emerson
davide at dalyn.co.nz
Wed Oct 29 15:53:27 CST 2003
Thanks everyone for the feedback so far. The storing of the data in a temporary file is not the problem - the problem is how I can use that data with the SQL BE and not have two people logged in as the same user overwriting each others table of data (remember 'Users' have been set up more as job functions so that individuals don't have their own log on - they log in as manager, or operations, or marketing. This means that we are not constantly setting up and deleting individual log ons as people come and go). I may just sit on this one and see if any bright ideas hit me over the next week. David At 29/10/2003, you wrote: >David, > >You would write a local file with something like > ><TableName>Customer</TableName> ><LastRecord>12345</LastRecord> > >Your customer form would need to look at this file >and get the place to go to from it. > >It is like the days when we used the ini file >to do similar things. > >Robert > >At 02:07 PM 10/29/2003 -0600, you wrote: >>Date: Thu, 30 Oct 2003 09:07:31 +1300 >>From: David Emerson <davide at dalyn.co.nz> >>Subject: Re: [dba-SQLServer]Linking to Local Table >>To: dba-sqlserver at databaseadvisors.com >>Message-ID: <5.2.0.9.0.20031030090706.00b2e0b0 at mail.dalyn.co.nz> >>Content-Type: text/plain; format=flowed; charset=us-ascii >> >>Martin, >> >>Can you explain further please. >> >>David >> >>At 29/10/2003, you wrote: >> >Bit out of the blue this but what about a local XML file. >> > >> >Martin >> > >> > >> > >> > >> >----- Original Message ----- >> >From: "David Emerson" <davide at dalyn.co.nz> >> >To: <dba-sqlserver at databaseadvisors.com> >> >Sent: Wednesday, October 29, 2003 10:32 AM >> >Subject: RE: [dba-SQLServer]Linking to Local Table >> > >> > >> > > Thanks David, >> > > >> > > I think I might have a problem here with temp tables. Because the >> people >> > > who will be using the client list will be logged on as the same >> used, any >> > > temp tables they create will have the same user name, therefore >> >overwriting >> > > themselves. >> > > >> > > Are you sure it is not possible to set up a connection with another data >> > > source other than the main SQL BE? >> > > >> > > David > > >_______________________________________________ >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 0064 4 478-7456