We have several clients with access to reports (provided via Views). The reports for each client are separated by being under a different SQL Server 2005 Schema. Obviously we can get each client to link to their Views but the client wants things to work like an ADP - that is, as reports are added, they would automatically appear on 'opening' the Access 'project' - with no formal linking of the new Views. Is there a way to do this? (An Access 2003 ADP does not even see the Schemas and, therefore, any views in them.)

Software/Hardware used:
Access 2007, SQL Server 2005