Wednesday, December 09, 2009

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.

1 comment:

Alex said...

I frequently work with access files,but yesterday I was astonished. Because my files were lost irrelatively unexpectedly. To my good fortune I entered a friend's house and saw there an interesting tool on his PC. I used the Google and found it on a soft blog - Repair MDB file. I wondered when it resolved all my problem for a minute and absolutely free it I didn't make a mistake. I recommended it for my friends and they told me: Thanks. And gave me a bottle of wine)) Protection Status