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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!