I feel cloud computing represents the next big platform change in the software industry and the most significant transformation since the introduction of the Internet in the mid's. It will literally revolutionize the way we create, test, host, and deploy applications, and can do it at a fraction of what it costs us today.
Read my article Microsoft Azure and Cloud Computing What it Means to Me and Information Workers to learn more about how I see cloud computing impacting our community. Instead of worrying about the hardware and deployment issues around applications, one can focus on building the solution and using the enterprise quality cloud platforms which previously didn't exist or were prohibitively expensive and difficult to use.
With Microsoft Access and SharePoint , Access applications in limited form can be deployed over the Internet. From a Microsoft Access database, you can connect to the database and use those tables the same way you could link to SQL Server databases on your network or SQL Express on your desktop.
For a fraction of the cost of buying and setting up a SQL Server box on your network, you can have Microsoft do it for you without worrying about licenses, downtime, hardware, etc. It's pretty simple: Version Comparison Matrix and Free Downloads page for more information and download links. They simply need to have the ODBC driver installed on their machine. From the Azure portal for your database, choose "Set server firewall", then add the IP addresses.
Not sure what your IP address is? Use the WhatsMyIP. You can define your DSN data source name either at the user, system machine , or file level. The first two are fine if you'll only be connecting to the SQL Azure database from your machine. To easily share the connection information with other machines, select the File DSN tab which creates a file that you can share over your network or send to other people: Press the [Add] button to create a new data source.
You can use an older version if your users already have it installed on their PCs and you aren't using the newer SQL Server features since that release. You can install multiple drivers on the same PC. There are 64 and 32 bit versions of the ODBC drivers. ODBC Driver For a history of SQL Server versions, visit our page: Significant performance problems are associated with using those old drivers against newer versions of SQL Server. Then specify the name of the file to store the information and press [Next] and [Finish] to verify it.
We'll create a sample DSN for our project. When you press [Next] with valid entries, this screen appears: Select the name of the database you created on SQL Azure. The default is master, but hopefully your database is named something more descriptive. Press [Next] to reach the final screen: Make sure you check the "Use strong encryption for data" option, then press [Finish]. A screen will appear to let you test your settings.
Press the [Test Data Source] button. If everything is okay, a screen like this appears: In our case, we'd like to link to the database so we always have the latest data: Select Tables It'll prompt you again for the password. Once you provide that, the list of tables from the SQL Azure database are presented. Select them like you would for any other data source. If you want to avoid entering the database password every time you open the linked table in Access, be sure to check the Save Password option: By choosing the option to save the password in the Access database, a security hole is created.
You'll need to decide if this risk is worth taking over the convenience of not entering the password each time. If you choose to save the password, you are prompted that this is a security issue: There are a few problems with this dialog box: The Help button gives no relevant information The dialog box appears for every table you selected, so you need to manually select Save Password for each one Once you get through that which has nothing to do with SQL Azure , you'll find your database has linked tables and views to SQL Azure.
Open and use the tables and views just like any other SQL Server data source. From the database container, right click and select Link Tables. After this, the dialog to Select the Data Source File appears which is similar to the steps described earlier for Access , and Imagine what you can do with Access having that kind of scalability and enterprise quality support and bandwidth. Hope this helps. Good luck and I hope to learn what you're doing or would like to do with Access and Azure.
Blog about it with me here.
Microsoft Cloud App Security access policies enable real-time monitoring and control over access to cloud apps based on user, location, device, and app. You can create access policies for any device, including devices that aren't domain joined, and not managed by Windows Intune by rolling out client certificates to managed devices or by using. Microsoft Azure is an open, flexible, enterprise-grade cloud computing platform. Move faster, do more, and save money with IaaS + PaaS. Try for FREE. Access; Install; Account The Microsoft cloud services for files. OneDrive for Business OneDrive More Less. When it comes to storing files, there are three Microsoft cloud services to choose from. Summary of the three Microsoft cloud services. Cloud service. Account .
Old Office logo Office retail pack Microsoft first announced Office in October ; beginning with a private beta with various organizations, leading into a public beta in April , and reaching general availability on June 28, Facing growing competition from Google 's similar service Google Apps , Microsoft designed the Office platform to "bring together" its existing online services such as the Business Productivity Online Suite into "an always-up-to-date cloud service" incorporating Exchange Server for e-mail , SharePoint for internal social networking, collaboration, and a public web site , and Lync now Skype for Business for communication, VoIP , and conferencing. The server components were updated to their respective versions, and Microsoft expanded the Office service with new plans, such as Small Business Premium, Midsize Premium, and Pro Plus. The plan is aimed at mainstream consumers, especially those who want to install Office on multiple computers. With these new offerings, Microsoft began to offer prepaid Office subscriptions through retail outlets alongside the normal, non-subscription-based editions of Office , which, in comparison, are only licensed for use on one computer. Power BI is primarily incorporated into Excel, allowing users to use the Power Query tool to create spreadsheets and graphs using public and private data, and also perform geovisualization with Bing Maps data using the Power Map tool previously available as a beta plug-in known as GeoFlow. Users will also be able to access and publish reports, and perform natural language queries on data.