susan harkins

Articles

Reap the benefits of using VB ActiveX .dll files in Active Server Pages

September 3, 2003 7:00am PDT

Transferring business logic to Visual Basic ActiveX .dll files can increase the performance of your Active Server Pages. Find out how to implement this technique and see how much more efficiently...

14 Latest comment by blj

Articles

Using Access to build a front end for SQL Server

September 2, 2003 7:00am PDT

What are the advantages of using Access as the front end to a SQL Server database? For starters, it's likely that your client's users will be more familiar with it, and it's relatively easy to put...

14 Latest comment by gilbertmarius

Articles

Use Microsoft Jet's ShowPlan to write more efficient queries

August 28, 2003 7:00am PDT

In large databases, an inefficient query can reduce performance to a crawl and incur the ire of users. The ShowPlan feature of the Access Jet engine can help you plan more efficient queries,...

2 Latest comment by m_sg2011

Articles

Quick Tip: Custom icons can make new apps friendly and familiar

August 26, 2003 7:00am PDT

Help users quickly acclimate themselves to a new application or report displaying custom icons that they can quickly relate to the applications purpose or to their company.

1

Articles

Upsize your Access database with SQL Server Data Transformation Services

August 15, 2003 7:00am PDT

Data Transformation Services can often upsize your Access database more efficiently than the Access Upsizing Wizard. Get a comparison of DTS and the AUW along with step-by-step instructions on how...

2 Latest comment by dalescott@...

Articles

Secure SQL Server: Identify user issues

August 14, 2003 7:00am PDT

Explore the fundamental concepts associated with user logins and permissions. Learn basic methods of logins, users, roles, and groups and the possible management strategies you can use to set up...

Articles

Make room for images in databases

August 13, 2003 7:00am PDT

There are a few options available to you when deciding where images will reside in your Web site. You can put them in the database, link them externally, or use in a second database. Here are the...

7 Latest comment by NZ

Articles

Provide easier navigation between Access main and subforms

August 13, 2003 7:00am PDT

Form navigation within Microsoft Access can prove tricky, especially if an app hasn't simplified the process for novice users. See how to create a Visual Basic event procedure to make navigating...

5 Latest comment by rb_ak

Articles

Secure SQL Server: Installing for security

July 29, 2003 7:00am PDT

Securing SQL Server is vital to the proper design of any database system. In this series, you get the lowdown on how to install SQL securely, protect data from prying eyes, and ensure its validity.

Articles

Upsizing an existing Microsoft Access database

July 17, 2003 7:00am PDT

The Upsizing Wizard in Microsoft's Access database software makes transforming to SQL Server mostly painless. But even the wizard needs fine-tuning for a smooth transition. Find out how to...

4 Latest comment by mattohare@...

Articles

SQL Server: Design for security from the start

July 15, 2003 7:00am PDT

Security in the development of a SQL Server database must be a priority right from the start, beginning with the design process. Familiarize yourself with these guidelines before you start your...

1 Latest comment by mattohare@...

Articles

Step-By-Step: An introduction to SQL Server Profiler

July 9, 2003 7:00am PDT

Discover how SQL Server Profiler works

15 Latest comment by gpshiburaj

Articles

Exporting Access schema using XML

July 2, 2003 7:00am PDT

Often when you need two applications to cooperate most, compatibility problems emerge. Microsoft Access supports Extensible Markup Language (XML), which makes it easier to import and export data...

5 Latest comment by Tony Navarro

Articles

Jet SQL and T-SQL handle duplicate values differently

June 19, 2003 7:00am PDT

Access databases can use two formats, Jet SQL and Transact-SQL, and they don't handle queries using TOP and ORDER BY in the same way. Find out how the formats differ and how to work around it.

Articles

Build Your Skills: Add a pseudo status bar to a Microsoft Access form

June 17, 2003 7:00am PDT

Customize Access applications

4 Latest comment by andy@...

Articles

Installation considerations for SQL Server Desktop

June 11, 2003 7:00am PDT

SQL Server Desktop comes with many handy features. However, depending on whether you're upgrading or performing a new install, the installation could be problematic. This article sorts out the...

3 Latest comment by mmaloof@...

Articles

How to manipulate command bar and control objects in Access

June 10, 2003 7:00am PDT

Utility forms and add-ins are great time savers. Learn how to build a simple utility form in Access that displays command bar and control objects, so you can enable or disable them with a click.

3 Latest comment by shantelle1109

Articles

Advantages of using the ADO Command object

May 21, 2003 7:00am PDT

The Command object offers several unique advantages over the ADO Recordset object for programmatic data updating. This article gives specific code examples that display the Command object's...

7 Latest comment by sara_h

Articles

Avoid Null value conflicts between Access and SQL Server

May 20, 2003 7:00am PDT

Handling Null values is tricky, but avoiding Null errors between Access and SQL Server can be downright daunting. Find out which Null-handling functions are platform-specific and which Null...

5 Latest comment by rahat@...

Articles

Ensure data integrity with proper database design

May 19, 2003 7:00am PDT

Data is the backbone of application development, so data accuracy is imperative. Take advantage of referential integrity to protect your database from invalid data.

22 Latest comment by Mstotou