INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Data Access

Using Crystal Version 7 with MS Access 2000 by HowardHammerman
Posted: 27 Oct 01

If you are still using Crystal Version 7 (and there are many good reasons to do so) and you upgrade your computer to Access 2000 and you connect to your Access 2000 database using Crystal's native drivers, you will probably get the following error message when trying to open a table:

"Error detected by database DLL" connecting to Access 2000 natively from Crystal Reports 7

If you try to create a new report in this situation you will not see the field names. The solution is to download Crystal's Access 2000 drivers from their download site. Go to
http://support.crystaldecisions.com/communityCS/FilesAndUpdates/access2000drivers.zip.asp
to download a zip file containing new drivers.

The file contains the following *.dll native drivers:

P2bdao.dll
P2irdao.dll
P2ctdao.dll

Rename or delete the files on the complaining machine and place these in the same folder as the old files. You should probably re-boot to get thing right.


Howard Hammerman, Ph.D.
Hammerman Associates, Inc.
http://www.hammerman.com
800-783-2269
Hammerman Associates, Inc. provide Crystal Reports training,
consulting, course material, utilities and software. Consultants are available throughout North America for short or long-term assignments.

Back to Business Objects: Crystal Reports 4 Other topics FAQ Index
Back to Business Objects: Crystal Reports 4 Other topics Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close