User`s guide
DAO uses Microsoft's Object Linking and Embedding (OLE) technology to provide access to Access
data through an object-oriented approach.
In addition to Access database tables, Crystal Reports can open and use Access queries through DAO.
If you are not familiar with Access queries, refer to your Access documentation. Search also for the
topic called "Opening Access queries through DAO" in the
Crystal Reports Online Help
.
Note:
• Access Parameter queries and Cross-tab queries can only be opened through an ODBC connection.
Search for the topic called "Opening Access queries through DAO" in the
Crystal Reports Online
Help
for more information. Access Action queries are not supported by Crystal Reports.
• When opening Access queries in a report, make sure the Views and Stored Procedures options are
toggled on using the Database tab of the Options dialog box in Crystal Reports. This ensures that
the queries will be visible when you open the Access database.
To translate information and data to and from DAO, the Report Designer uses the DAO translation file
crdb_dao.dll.
Secured Microsoft Access Databases
If you will be using secured Access databases, the SystemDB parameter in the Windows Registry
database must be set to point at the path where the System.mdw (Access 95 and later) file is located.
On Windows NT, the SystemDB parameter is located in the following Registry key:
• Access 97
\\HKEY_LOCAL_MACHINE\Software\Microsoft\Office\8.0\Access\Jet\3.5\Engines
• Access 2000
\\HKEY_LOCAL_MACHINE\Software\Microsoft\Office\9.0\Access\Jet\4.0\Engines
A.2.4.5 Pervasive
Crystal Reports connects to the Pervasive (formerly Btrieve) engine through the translation files
crdb_p2bbtrv.dll, p2bbtrv.dll, and p2ctbtrv.dll.
The Pervasive engine is a complex collection of DLLs and EXEs that are specific to the version of
Pervasive you are using. For more information on the different Pervasive engine files, refer to your
Pervasive documentation.
Note:
• Pervasive must be configured correctly for Crystal Reports to read Pervasive databases. If Pervasive
is already configured correctly on your system, Crystal Reports can use your Pervasive data
immediately upon installation. Crystal Reports automatically installs the Pervasive files that it requires
to read Pervasive data. Refer to your Pervasive documentation to make sure the Pervasive engine
is configured correctly.
2012-03-14648
Accessing Data Sources