Using Microsoft Access with Pervasive Data

Show this topic in Library frames

This chapter discusses how to use Microsoft Access to view and manipulate data in the sample database, which is installed with Pervasive.SQL. When you use Access to connect to Pervasive data, you must use an ODBC Interface.

Pervasive.SQL provides communication between Pervasive engines and ODBC-enabled applications. ODBC does not process the database requests itself. Instead, it accepts database requests from ODBC-enabled applications-such as Access-and translates the requests into Pervasive.SQL calls.

This chapter contains the following sections:

"Lesson 1: Setting Up Your Environment" on page 2-2

Lesson 2: Linking to Tables

Lesson 3: Importing Tables

Lesson 4: Creating a SQL Pass-Through Query

Note
The lessons in this chapter show screens from Access 97 only, but the steps in Access 2000 are almost exactly the same.