Contact US

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.

Students Click Here

Crystal Error in MAS90 3.51 Purchase Order printing

Crystal Error in MAS90 3.51 Purchase Order printing

Crystal Error in MAS90 3.51 Purchase Order printing

Module: Purchase Order
Issue: When attempting to print a Purchase Order, the following error message occurs:

Crystal Error: Error detected by database DLL.

Thanks for any help.

RE: Crystal Error in MAS90 3.51 Purchase Order printing

It is my guess that you just recently found an old copy of MAS v3.51 and installed it. Would this be correct?

"Error detected by database.DLL", when printing or previewing Crystal reports
Entry Type: Informational

Product: Sage MAS 90 ERP, Sage MAS 200 ERP, Sage MAS 200 ERP - SQL Server Edition

Application: Crystal Reports

Version Reported: 3.61

"Error detected by database.DLL", when printing or previewing reports using Crystal Reports. Error "ODBC error: [PROVIDEX] [PVX ODBC DRIVER] [FILEIO] Physical file is not accessible. On version 3.71 may get "Crystal database is in use by another user"

Note:  "PESTARTPRINTJOB" also appeared on the error screens in older Sage MAS 90 versions, but should no longer appear on newer versions.

Possible Resolutions:
Note: "Error detected by database.DLL" is a very generic error.
For a more specific error, click on the 'Design' or 'Form' button and refreshing the form or report from within Crystal Reports (click on the Lightning Bolt button).  Search the Knowledgebase for the specific error.

The error might occur for the following reasons:

The user has been denied access to the files with ODBC Table/File security or ODBC User Security.
The report is pulling data files that do not exist for the Company Code.
The UNC path may be incorrect in Alternate Directory Maintenance (Sage MAS 200).
The form or report may have been created in a prior version and needs to be converted to the current version.
The P2SODBC.DLL file may be the incorrect version
There are two or more left outer joins.  The SOTAMAS90 dsn only supports a single left outer join.
A report run from the Custom Reports menu is accessing a table or file outside Sage MAS 90 or 200.  The report can only be run outside of Sage MAS 90 or 200.

RE: Crystal Error in MAS90 3.51 Purchase Order printing

Thanks for the help.  No finding of the old software, the client has not upgraded past 3.51 from when I sold it to them 15 years ago.  Good amortization.


RE: Crystal Error in MAS90 3.51 Purchase Order printing

Based on all you have posted the client has no other option but to upgrade to a modern version of MAS or some other accounting package.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

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