Learning to develop Microsoft Access Cloud applications using an Azure SQL Database as a back
end is new territory for many. Although there are many similarities to developing an Access
application that uses a hosted SQL Server database, there are also a number of differences
that can trip you up unless you are aware of them. For example using
OLE DB and
ADODB with SQL Azure is not supported. And even though
it is possible
to use ADO in SQL Azure by using the SQL Server Native Client Microsoft
informs us that SQL Server 2012 will be
last version of SQL Server to support
the SQL Server Native Client OLE DB provider. This
is the type of critical information we work to provide.
The biggest problem I faced when I began developing with Access and SQL Azure was
finding the information and help I needed. I have found no single web page, site,
help file, document, or source of information on how to develop Access Applications
that could use SQL Azure. I spent countless hours using online searches, downloading
documents, using SDKs, reading books and reading online to get the necessary information
and solve problems. Some vital information could not be found so at times I had
to learn through trial and error. There needs to be a better way for Access developers
to get the crucial information we need to develop with SQL Azure.
So I am gathering together information, links, tips, scripts, and articles and building a
Microsoft Access and SQL Azure Information Center for
Developers to save you some valuable time and headaches. We will list important links, downloads,
articles and blogs, scripts, code samples, tips, and new developments.
You are welcome to submit your own tips, code samples, links, comments, and articles.
You can contact me at
Even as I was preparing this post I received a request in an email from a developer
asking where they could get information about developing Access and SQL Azure applications.
It looks like I had better get busy.
While I am busy you can download and try out our Free
Demonstration Application that shows a little of what can be done with Access and SQL Azure.
We use Microsoft Azure SQL Databases to provide safe and affordable 24/7 internet access to your company's vital information.
Contact us for a Free Consultation, feedback, or more information:
Page layouts based on Matthew James Taylor's Perfect multi-column CSS liquid layouts