Articles on Microsoft Access

The following articles were written by Baarns Senior Consultant, Marty Wasznicky for the Advisor Publication. In October, Advisor Publications made Marty a Contributing Editor for the Access-Office-VB publication. Get your copy from your newsstand today!

From the August edition of the Access-Office-VB Advisor publication

Store, Distribute, and Protect VBA with Visual Basic—written by Marty Wasznicky

Marty demonstrates how to build reusable COM components for your Office projects using Visual Basic to create ActiveX DLLs. The user is walked through porting Microsoft Access VBA attachment handler routines in VB.

From the May edition of the Access-Office-VB Advisor publication

Who's in your Database—written by Marty Wasznicky

Marty demonstrates some advanced techniques for dynamically determining who is currently using a database. The methodology replicates the process Microsoft Access uses natively to determine the User and Machine Name of all the currently logged on users.

The following article was published in the February edition of the Access-Office-VB Advisor publication

Microsoft Access Applications That Rock—written by Marty Wasznicky

Marty demonstrates how to use ODBCDirect to improve your performance when retrieving enterprise data. The user is walked through the construction of an Microsoft Access application using ODBCDirect to retrieve and data across the Internet.

From the November issue of the Visual Basic Programmer's Journal publication

Use ActiveX Data Objects in Excel—written by Marty Wasznicky

In this article, Marty takes a look at the beta version of ADO 1.5. Some of the new features are described as well how to easily integrate the technology into Microsoft Excel.

From the November issue of the Access-Office-VB Advisor publication

Error Handling with a Touch of Class—written by Marty Wasznicky

The mark of a good application developer is how well errors are anticipated and planned for. Marty demonstrates how to effectively wrap up error handling routines in a simple Class module so they can be easily implemented in all your projects.

From the September issue of the Access-Office-VB Advisor publication. This article can also be seen on Microsoft's Site.

Fast Path to the Enterprise: ActiveX Data Objects—written by Marty Wasznicky

This article is an in-depth explanation of ADO 1.0 and OLE DB, Microsoft's new object model and technology for accessing universal data in the enterprise. The article discusses the current strength and weaknesses of this new technology and how it compares to existing object models like RDO, DAO, ODBCDirect. Performance testing is documented as well as coding conventions for the new object model. Code and sample application written for the article, can be obtained through Advisor Publications.

From the July edition of the Access-Office-VB Advisor publication

Building an ODBCDirect Connection Class—written by Marty Wasznicky

This article expands upon the uses of ODBCDirect by walking the reader through the process of creating a Connection Class module and managing Connections via a Collection. The article goes into depth about the various coding structures to use and how to optimize it for client server development.

From the June edition of the Access-Office-VB Advisor publication

ODBCDirect: The Fast Enterprise Data Link—written by Marty Wasznicky

This article gives a detailed explanation of ODBCDirect, Microsoft's new client server connection mode exposed through Office 97's Data Access Object 3.5 object model. The article goes into length about its roots, benefits, and uses.

Copyright© 1996-1999, Baarns Consulting Group, Inc. - All rights reserved.