{"id":5030,"date":"2013-03-26T18:28:16","date_gmt":"2013-03-26T18:28:16","guid":{"rendered":"http:\/\/craftydba.com\/?p=5030"},"modified":"2013-03-27T15:31:50","modified_gmt":"2013-03-27T15:31:50","slug":"ms-access-n-azure-sql-database","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=5030","title":{"rendered":"MS Access -N- Azure SQL Database"},"content":{"rendered":"

\"\"<\/a><\/p>\n

I knew Windows Azure SQL Databases<\/a> have been around for a couple of years but never had the time or need to research them. With a possible data center consolidation in the future, I was wondering if my company could leverage a Windows Azure SQL Databases to reduce the total cost of ownership for certain applications?<\/p>\n

Today, I will be working with the sample [AUTOS] cloud database that I created in a previous blog. I want to test connectivity to this cloud database using common programs and tools that my users or developers might choose. <\/p>\n

I will be testing how a power user can use MS Access<\/a> to manipulate data within a Azure database. <\/p>\n

I am assuming that you read my article<\/a> on creating a ODBC connection. The only change is the source of the database. Use the \u201cnpx8eftmd0.database.windows.net\u201d server address as the source. Before it was local, now it is in the cloud. <\/p>\n

You will also need to create Access Linked Tables using my article<\/a> as a reference. Your database should look like mine below with two linked tables and one linked view.<\/p>\n

\"\"<\/a><\/p>\n

Performing a CRUD – (create, read, update & delete) test will make sure Azure performs like any local database we worked with before. <\/p>\n

First task is to create or INSERT<\/span> a new record for the Plymouth make.<\/p>\n

\"\"<\/a><\/p>\n

Second task is to incorrectly UPDATE<\/span> the Ford maker to Henry Ford.<\/p>\n

\"\"<\/a><\/p>\n

Third task is to correctly UPDATE<\/span> the Ford maker record back to its original state.<\/p>\n

\"\"<\/a><\/p>\n

The fourth and last task is to DELETE<\/span> the new Plymouth record from the table.<\/p>\n

\"\"<\/a><\/p>\n

Since MS Access automatically updates the data grid after a change, we do not need to test the read or SELECT<\/span> functionality.<\/p>\n

In summary, connecting a MS Access database requires the creation of a ODBC data source using the newest client driver and the creation of linked tables to access\/manipulate the remote tables. Next time I talk about Azure, we will be exploring how to pull data from Azure into MS Excel.<\/p>\n

Sample Database<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

I knew Windows Azure SQL Databases have been around for a couple of years but never had the time or need to research them. With a possible data center consolidation in the future, I was wondering if my company could leverage a Windows Azure SQL Databases to reduce the total cost of ownership for certain applications? Today, I will be working with the sample [AUTOS] cloud database that I created in a previous blog. I want to test connectivity to this cloud database using common programs and tools that my…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[786,784,33,30,15,412,799,37,32],"class_list":["post-5030","post","type-post","status-publish","format-standard","hentry","category-db-dev","tag-azure-sql-database","tag-cloud-computing","tag-delete","tag-insert","tag-john-f-miner-iii","tag-ms-access","tag-odbc-connection","tag-select","tag-update"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/5030","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5030"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/5030\/revisions"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5030"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5030"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5030"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}