|
|
-
|
|
One of the best things about SQL Azure is how easy it is to manage User security. In this article we will show you how you can use Microsoft Access to add individual Users to Database Roles which makes managing User security much easier.
The Benefits of Using Flexible Database Roles
If you grant......
|
|
-
|
|
In this article we will demonstrate how you can use a Pass-through query in Access with VBA code to create SQL Azure Logins. Microsoft Access can then use the Login and Password to gain access to SQL Azure Tables, Views, and Stored Procedures. We will create a Login using SQL in Access similar to th......
|
|
-
|
|
Why do we need a SQL Azure Database User Account? An Access Database cannot access SQL Azure Objects such as Tables, Views, or Stored Procedures without one. That is, unless you use your SQL Azure Administrator account which would be living very dangerously if you were distributing your database to ......
|
|
-
|
|
I was shocked. I had heard that Constants and Variables could be seen by opening an accde or mde file with a hex editor but when I opened my file I was stunned to see so much of my data, objects, and code in plain text. I am not an Access Security expert, but I decided to take on the challenge of th......
|
|
-
|
|
When it came to creating DSN-Less Linked Tables I had always used a procedure that deleted the TableDef and appended a new one until a problem occurred. The code I was using to save Linked Tables as DSN-Less Tables was not working with some of the Views in SQL Azure. This was a serious problem becau......
|
|
-
|
|
Here are some How To’s to help get you started with SQL Azure. Some
of them can also help with SQL Server.
How to Create Logins in SQL Azure
How to Create Database Users in SQL Azure
How to Build an ODBC Connection String in Access
How to Migrate a SQL Server Database to SQL A......
|
|
-
|
|
Here are some of the main links from
The Microsoft Access and SQL Azure Information Center for Developers about
using Microsoft Access as a front end (GUI) for SQL Azure.
Much of the information here will also benefit Access developers using Hosted SQL
Server back en......
|
|
-
|
|
Learning to develop Microsoft Access Cloud applications using SQL Azure as a back end is new territory. 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......
|
|
-
|
|
Steve Yi’s PDC 2010 video, “What’s
New in SQL Azure?”, reveals the new features Microsoft is now adding to
SQL Azure. The features include a new SQL Azure Developer Portal and web-based
Database management tools. The new SQL Azure Data Sync CTP2 e......
|
|
-
|
|
The Security Risks of Distributing SQL Azure Applications Using Microsoft Access
When we distribute Microsoft Access applications that use SQL Azure it is vital that we make our applications as secure as possible. Whether we use a DSN (Data Source Name) to link tables and pass-through queries to SQ......
|
|