Microsoft Access and SQL Azure

MS Access is one of the oldest of Microsoft products cherished by many. It makes business sense to enable MS Access developers to leverage their knowledge base to create front end while pushing their data to SQL Azure thus making use of Microsoft Access Projects supported in the 2007 version. This not only increases SQL Azure platform adoption but also that of MS Access. The main problem, as it stands now is connectivity between MS Access and SQL Azure. The ODBC connectivity can be improved if a driver can be created specifically for SQL Azure, or the existing driver tweaked to support SQL Azure. The ODBC driver that downloads with SQL Server 2008 R2 Nov-CTP has problems to connect via ODBC.