ACCESS 2007 and SQL Server 2005 Schema Updates
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
Software/Hardware used:
Access 2007, SQL Server 2005
ASKED:
August 13, 2009 2:56 PM
UPDATED:
August 13, 2009 3:26 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
