Introduction

Welcome to the Microsoft® Office 95 Data Access Reference, your reference for using data access objects and SQL to create data access applications in Microsoft Access and Microsoft Excel. This book contains information on the data access objects, methods, and properties and the SQL statements and functions available to you when you program in Visual Basic® in Microsoft Access or Microsoft Excel.

Microsoft Access and Microsoft Excel both include the Microsoft Jet database engine. The Jet database engine creates and stores the structure of your database and maintains all the data within it. From Visual Basic, there are two ways to work with the Jet database engine to control the structure and content of your database. You can use either data access objects or Microsoft Jet database engine SQL to create, alter, and delete objects and data in your database.