SQL Server/Office Integration


15 results found for SQL Server/Office Integration, displaying items 1 - 15

Views and Stored Procedures This article is only available to subscribers.  Sign up now and get instant access!

This column looks at the SQL-DMO syntax required to examine and manipulate SQL Server views and stored procedures.

SQL Server Magazine

Creating Tables with SQL-DMO This article is only available to subscribers.  Sign up now and get instant access!

Develop your basic SQL-DMO programming skills by creating tables in Access projects.

SQL Server Magazine

SQL-DMO: Learning the Basics This article is only available to subscribers.  Sign up now and get instant access!

SQL-DMO lets you program custom solutions containing administrative functions for SQL Server by exposing objects, methods, properties, and events through a COM interface.

SQL Server Magazine

Programming SQL Server Security This article is only available to subscribers.  Sign up now and get instant access!

You can use SQL-DMO to program a custom security interface.

SQL Server Magazine

Homegrown Security Solutions This article is only available to subscribers.  Sign up now and get instant access!

Using object permissions and user-defined roles, you can fine-tune secure access to database objects.

SQL Server Magazine

Securing SQL Server Tables This article is only available to subscribers.  Sign up now and get instant access!

In this second article in a security series, Rick Dobson shows you how to set up SQL Server account security through Access projects.

SQL Server Magazine

Access Granted This article is only available to subscribers.  Sign up now and get instant access!

You can successfully log in to SQL Server from an Access project when you understand login process aspects such as authentication modes and login accounts.

SQL Server Magazine

Custom Datasheets This article is only available to subscribers.  Sign up now and get instant access!

Learn how to use FrontPage 2000 to customize SQL Server datasheets for publication to the Web or an intranet.

SQL Server Magazine

Dynamic Datasheets This article is only available to subscribers.  Sign up now and get instant access!

Learn how to publish your SQL Server datasheets with FrontPage 2000.

SQL Server Magazine

Filtering Data with Access Forms This article is only available to subscribers.  Sign up now and get instant access!

The author demonstrates two approaches to programming custom filters for the SQL Server Pubs database with Access forms.

SQL Server Magazine

Datetime Values in Access Projects This article is only available to subscribers.  Sign up now and get instant access!

Learn how Access handles dates and times to extract results in the format you need.

SQL Server Magazine

Programming SQL-DMO from Access This article is only available to subscribers.  Sign up now and get instant access!

Learn how to build a custom application with Access projects and SQL Distributed Management Objects (SQL-DMO).

SQL Server Magazine

Securing SQL Server Through Access This article is only available to subscribers.  Sign up now and get instant access!

Here are the basics of SQL Server security for Access 2000 projects.

SQL Server Magazine

Control the Flow This article is only available to subscribers.  Sign up now and get instant access!

Knowing how to use T-SQL's control-of-flow statements empowers Access developers to write code that operates conditionally depending on user input.

SQL Server Magazine

Adapting BOL Examples for Access This article is only available to subscribers.  Sign up now and get instant access!

Learn by example by using stored procedures from Books Online with Access projects.

SQL Server Magazine

Add these Headlines to your Website