Results for:
SQL Server

• SQL Server Migration Assistant adds Access features

  29 Apr 2011

  Microsoft has announced the release of SQL Server Migration Assistant (SSMA) v5.0, a family of products to further simplify the user experience in automating the migration of Oracle, Sybase, MySQL and Microsoft Access databases to SQL server or SQL Azure. Access users will be happy to learn that SSMA...
• Power Tip: Improve the security of database connections

  8 Apr 2011

  This post about making ODBC connections more secure is provided by Access MVP Ben Clothier. Now and then, we come to a point where we decide to upsize an Access database to a server-based RDBMS. The reasons for upsizing can vary, but a common theme is security. With a server-based RDBMS, we have more...
• Evaluating database needs across SQL Server, SQL Azure, SharePoint and Access

  10 Jan 2011

  Every now and then we hear from customers who want some cheat sheet or Excel-based "calculator" to help them decide what technology to base their application on: SQL Server, SharePoint, Access, etc. While in some cases (especially in the extremes) the decision is relatively easy to make, it is very common...
• Follow-up paper from FMS, Inc. on a popular topic: SQL Azure and Access

  1 Sep 2010

  Two recent papers written by Luke Chung of FMS, Inc. about SQL Azure and Access have created a lot of interest on his blog , as well as a few linked forum discussions. In response, Luke has written a follow-up paper about deploying an Access database once it’s linked to SQL Azure. He has also revised...
• Two new white papers about Access and SQL Azure from FMS, Inc.

  20 Aug 2010

  Luke Chung has published a couple of white papers about Access and SQL Azure. You can read Luke’s blog post here , or link to the papers directly here: Microsoft Azure and Cloud Computing...What it Means to Me and Information Workers Microsoft Access and Cloud Computing with SQL Azure Databases (Linking...
• Handling the SQL Server bigint data type in Access 2007 using ADO

  10 Jun 2009

  Today’s guest blogger is Vinny Malanga. Vinny is the CTO of IMI Software, Inc. , which specializes in software development for the property management industry. I recently received a call from a client asking for help on how to use the SQL Server bigint data type in a disconnected Access .accdb file...
• Channel 9 video about Access and SQL Server Migration

  18 Mar 2009

  Luke Chung from FMS recently talked on Channel 9 about his view of Access solutions -- where they fit well, what challenges users and developers often face in creating and maintaining them, and how they have evolved from standalone desktop solutions to having the capability to be integrated with web...
• Using SQL Server 2008 Table-Valued Parameters (TVPs) from Access

  28 Jan 2009

  Today’s guest writer is Mary Chipman. Mary is a programmer-writer for the Data Programmability team at Microsoft and co-author of the classic Microsoft Access Developer's Guide to SQL Server . Table-valued parameters (TVPs) in SQL Server 2008 provide an easy way to marshal multiple rows of data from...
• Announcement: Storing Access apps and data in the cloud

  28 Oct 2008

  Today’s guest writer is Liam Cavanagh from the Sync Framework and SQL Services team. They are doing some cool stuff that allows Access developers to store their app and data in the cloud using SQL Server Data Services. Liam is looking for people that want to beta test an upcoming release early...
• Tech Talk: Using Access with SQL Server Panel Discussion from TechEd 2008

  19 Jun 2008

  There is a good talk available called Are we there yet? Successfully navigating the bumpy road from Access to SQL Server . Here is the description: “Use SQL Server, not Access”, is advice commonly handed out when the Jet database engine outgrows its usefulness. However, that’s often easier said than...