| Title |
Synopsis |
| Filtering
SQL Server Data with Access Forms |
Discover
two approaches to programming custom filters from Access forms.
These approaches rely on either an Access form's Filter property or the
ServerFilter property. The article demonstrates both approaches with the
authors table and an Access form that lets users filter authors by their
home state. Your needs and experience will help determine the best
method for you. |
|
|
Learn how
Access extracts dates and times from SQL Server databases in the formats
that you need. In particular, this article drills down on how to
use the Convert and DatePart function with a sample table containing
datetime values. |
|
|
SQL-DMO
lets you program anything that Enterprise Manager lets you perform
graphically. Access developers can program SQL-DMO from Access
projects to build subsets of SQL Server functionality into their custom
applications. This article shows you how easy it is to get started
doing this. |
Securing
SQL Server Through Access
|
Learn the
basics of securing SQL Server databases with Access projects. In
particular, you will discover the differences between login and user
accounts as well as roles. Step-by-step examples hold your hand
through the process of securing an Access database. |
| Control
the Flow |
This
article provides T-SQL and VBA samples that demonstrate the use of the
IF...ELSE statement in T-SQL stored procedures from Access
projects. The article also demonstrates how to process a Return
Value from a stored procedure in an Access project |
| Adapting
BOL Examples for Access |
SQL
Server Books Online (BOL) is one of the best routes for getting
up to speed on SQL Server, which might be why Microsoft makes BOL
available with SQL Server and the Microsoft Office 2000 Developer
Edition (MOD). Many BOL code examples target the SQL Server
Query Analyzer, but they need tweaking to work in the stored procedure
templates available with Access projects or in Visual Basic for
Applications (VBA) projects. This article gives Access developers
what they need to put BOL to work for them. |
| Using
SQL Server Stored Procedures with Access Projects |
Stored
procedures are a new, important topic for Access developers, but Access
developers switching to SQL Server with Access projects might find the
syntax of and techniques for building and using stored procedures
unfamiliar. Before Access 2000, Access developers couldn't create
stored procedures. With Access 2000 and Access projects, you can write
your own Transact SQL (T-SQL) scripts in stored procedures. Get
the basics in this article so you can start putting stored procedures to
use in your applications. |
|
|
The
Microsoft Data Engine (MSDE) makes SQL Server technology available in
development contexts that were previously restricted to the Jet database
engine. This new database engine, which ships with all versions of
Office 2000 that contain Access 2000, falls between SQL Server and Jet
in size and power as a compelling new option. |
| SQL
Server Views with Access 2000 |
With
Access 2000, developers can use Access's rapid prototyping tools to take
advantage of Access projects (a new file type) to build SQL Server
solutions. This article illustrates techniques for managing SQL
Server views from Access projects. |
| Defining
Databases and Tables with Access Projects |
This
article demonstrates techniques for easily creating SQL Server databases
and tables from Access projects. This is a new Access capability
introduced for the first time with Access 2000. |
| The
Power of Two: Office 2000 and SQL Server 7.0 |
Office
2000's new data-access capabilities—the introduction of ADO and the
new Access .adp file type—make it nearly as easy for developers to
connect with a SQL Server data source as with a Jet data source.
Get a rigorous intro to what you can accomplish with this article. |