| Title |
Synopsis |
|
Exploring Microsoft's Express Suite 2005 |
Have you taken a look at the new Express suite components from
Microsoft? You just might find that they offer some significant advantages
for your organization or you personally. This article give you a hands-on
feel from an early beta. The article works with three Express suite
components: Visual Basic Express, Visual Web Developer Express, and SQL
Server Express. |
|
Eventful Formatting for Access Forms |
Dynamically changing your form's properties at runtime can often
provide a better experience for your users. Lean some secrets for
dynamically changing your form's background as it gains and loses focus,
keeping subforms in view, and providing colorful feedback for data. |
|
Programming Pivot Tables for Access Forms |
Pivot tables represent a powerful way to convey the data in Access
databases, and they empower users to perform many tasks that used to
require custom programming. This article shows how you can enable your
users to manipulate data with pivot tables. |
|
Packaging Access 2003 Solutions |
Creating a reliable setup package for Access has often been fraught
with peril. This article looks at how well the latest version of Access
handles the difficult task of distributing your application. |
|
Doing XML with T-SQL |
This article gives you a quick and useful intro to using XML
templates. As you read it, you may also want to read or re-read Rick's
January 2004 article on using the Web Services Toolkit to create Web
Services and their clients, Tom Moreau's March 2001 column on feeding XML
to stored procedures, and the late Anton Britten's February 2002 article
on "getting the XML back in." |
|
Easily Creating Web Services and Their Clients |
Although the SQL Server 2000 Web Services Toolkit has been around
for years, a lot of organizations ignored it initially. Now that both Web
Services and .NET are more widely accepted, it may be time for you to
explore (and perhaps even champion!) the technology. Learn how to
Wes Services champion easily with this article. |
|
Programming Stored Procedure Parameters |
Learn how to program stored procedure parameters with ADO.NET and
VB.NET. To follow along, you'll need access to SQL Server 7.0, MSDE, or
SQL Server 2000 and to the Northwind sample database. |
|
Getting Started with Reporting Services |
Reporting Services is an enterprise system that integrates Visual
Studio .NET 2003 and SQL Server 2000 to facilitate the authoring,
publishing, management, and user access to data-based reports. It's a free
add-on to SQL Server 2000 from Microsoft, and an upgraded version is
likely to become an integral component of SQL Server 2005. This article
provides an overview of Reporting Services and shows how to get started
authoring reports with it. This article complements the built-in
documentation by highlighting the integral role Visual Studio .NET plays
in authoring reports with Reporting Services. |
|
Managing SQL Server From Access |
This article introduces the SQL-DMO (Distributed Management
Objects) object model and demonstrates its use from Access VBA to create
tables, modify metadata, populate tables, and more. |
|
Programming SQL Server Security |
This article shows you how to program SQL Distributed Management
Objects (SQL-DMO) from an Access project to perform three common tasks:
creating logins, adding database users, and assigning users to database
roles. By programmatically exposing a selected subset of security
features, you can remove the built-in Access project security interface
and customize the security information that a user can view. Access offers
several ways—such as selecting View, Toolbars, Customize—to customize its
built-in menus. |