Cannot find the Invalid object

[morechocolate]

We have an existing report, orginally created in Crystal 5, where we have two tables that need the database location changed. We changed the database locations in the main report and the subreport. When we run the report we get the following error:

ODBC error:[Microsofr][ODBC SQL Server Driver][SQL Server]Invalid object name 'MLDTXYR_200112'.

I verified the databases and I looked at the Sql Query in both the main and subreport, by the way the sub report does not even use the MLDTXYR_200112 table, and I can not for the life of me figure out where Crystal is seeing this table.

Any ideas? I really do not want to recreate this report. There are way too many formulas involved.

Thanks

MC

 

[synapsevampire]

Odd one...

It sounds like the table referenced isn't as it should be, perhaps you need to use a different connectivity (what version of CR and SQL Server?).

Try native or OLE DB.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[morechocolate]

The report was created in Crystal 5, but I get the error in when I try running in Crystal 8 as well.