"kk" <kk@yahoo.com.au> wrote in message
news:A7DFABB5-8012-4A70-B07F-682A67DA9BF1@microsoft.com...
>I am creating a project with microsoft access 2000 front end and sql server
> 2000 backend. When i print report from the form then what my system does
> is
> ,creates some views according to criteria from the form on the fly and at
> the
> end it links all those views and create final view and that final view is
> recordsource form my report. My problem is if another user prints the same
> report same time from another machine with different criteria then system
> overwrites all the views and both users come up with the same report. any
> help will be appreciated.
>
> Thanks
> --
> kk

"David Portas" wrote:

> "kk" <kk@yahoo.com.au> wrote in message
> news:A7DFABB5-8012-4A70-B07F-682A67DA9BF1@microsoft.com...
> >I am creating a project with microsoft access 2000 front end and sql server
> > 2000 backend. When i print report from the form then what my system does
> > is
> > ,creates some views according to criteria from the form on the fly and at
> > the
> > end it links all those views and create final view and that final view is
> > recordsource form my report. My problem is if another user prints the same
> > report same time from another machine with different criteria then system
> > overwrites all the views and both users come up with the same report. any
> > help will be appreciated.
> >
> > Thanks
> > --
> > kk
>
> Why not use some off-the-shelf reporting tool? Reporting Services for
> example? If you really must re-invent the wheel then you can't use the
> method you described. How about using parameterised stored procedures?
>
> --
> David Portas, SQL Server MVP
>
> Whenever possible please post enough code to reproduce your problem.
> Including CREATE TABLE and INSERT statements usually helps.
> State what version of SQL Server you are using and specify the content
> of any error messages.
>
> SQL Server Books Online:
> http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
> --
>
>