Crystal Report Error

[daneb]

Hi.

Has anyone here encountered this error before:

Error #20534
Error detected by database DLL

The error highlighted this line in my code:

CrystalReport1.Action = 1

This happened when I replaced a table in my Access database with another table of the same data strucuture and with new data in it. (The error didn't occur before the table replacement.) Before the above line is reached, there were still some computations to be made, and the results will be shown on the report. There were no errors in the computations, but when the above line was reached, the error showed up. The error message is very vague and doesn't say anything else.

Can anyone help me? Thanks for the info in advance!

[goddess_spanky]

I had the same problem in Crystal Reports 8.5 after I changed one of my database files. If you created the report in Crystal instead of from VB, you should be able to fix the problem by trying the below steps. If you created the report in VB using the CR Designer, then you may want to go to http://www.crystaldecisions.com/

The easiest fix is to open the report in crystal reports and select database > verify database.
If that doesn't work go to database > convert database drive then click on 'convert database on next refresh'. In the 'To: ' drop-down, select the same ODBC driver listed and press OK. Now select the DSN name used for the report. Click OK on the configure connection screen. You should then get a pop-up message indicating "the database file ' ' has changed. proceeding to fix up report!" Click OK.

Let me know if that works or if you still have problems.

AD

~goddess
[email protected]