How can I pre-filter a table that is used in a query in a live dat

D

dv999

How can I pre-filter a table that is used in a query in a live database?

I have about 47 queries (SQL text in a memo field in a table) that all
reference a few tables in the same database.
I would like to limit the table’s data instead of re-writing all the queries
to include further criteria. The queries are very complex and it is not
desirable to re-write the queries and use parameters.

This database is live on an ASP.NET web page and there may be multiple
people viewing the reports which are using these queries.

Since there are multiple users I can not simply copy the tables into another
database by clobbering the existing tables and remove the data that matches
the criteria and the queries could reference the same table names.

Note: I am developing and testing in Access 2007, but the web server uses
Access 2003.

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering a table by using criteria in another table 1
Query the same table three times 0
live query 4
Visio 2013: how do I auto-colour Shapes in alignment with pre-entered Shape Data? 0
How to Retrieve Data From Another Access Dataase Without Linking to It? 3
use field list from form to specify query fields 2
How Do Queries Work? 4
Query export as Table 2

Top