From: Jonathan on 11 May 2010 16:50
<sigh>There always seems to be another way to do things and at my current
skills level the other way is the better way</sigh>
"Bob McClellan" wrote:
> One method is to use a staging table that is purged and repopulated
> as per the end user's search criteria. add a column to this table:
> when you fire the sp...
> first: delete from YourTable where CurrentUser = @cu
> then, Insert into YourTable ( col1, col2, CurrentUser , etc.. )
> select ( col1, col1, @cu, etc... )
> "Jonathan" <Jonathan(a)discussions.microsoft.com> wrote in message
> > Hi, using Access 2003 and SQL 2005. I have an Access application that uses
> > a
> > combination of pass-through queries and dao recordsets to load forms and
> > reports. This is not an Access Project. My question is about design.
> > A search populates a table with parent record IDs. I then have a bunch of
> > stored procedures that use an inner join on this table to filter records.
> > In
> > a multiuser environment what is the best practice method to ensure that
> > the
> > table of IDs is not compromised by an user's search results? For example,
> > will using a ##temp table to hold the search result IDs give the required
> > outcome?
> > Any ideas or recommendations appreciated :-)
> > Many thanks,
> > Jonathan