Wednesday, March 7, 2012

Crystal 8.5 Cant Change Database Path in Code

Hi everyone,

I have used Crystal for about 7 years, and have never had this problem before. I am using Crystal 8.5 Developer, on WinXP Pro, with Delphi4 and using an Advatage database, I am trying to change the data location in code
eg: frmMain.crpe.Tables[inTbNo].Path := stDBPath; // this has worked for years.

I have also tried hard coding just to test it:
frmMain.crpe.Tables[0].Path := '\\Server\Server\Gigasoft\dbStockOrderBeta';
frmMain.crpe.Tables.Propagate := True;
// this still does not work

I have formatted the machine and reloaded only the bare minimum of software just incase there was some conflict, still no luck.

I have permanent tables in 1 folder and temp tables in another, the reports only use 1 or the other not both.

The reports that use the permanent tables are the ones causing the problem.

The reports using the temp tables seem to work OK, as they are constantly changing location to the temp locations depending on the user who is logged in.

I hope someome has had this problem and solved it before.

Thanks in Advance for any help
Daryl...What is the error you get?
Check the path is shared and accessible|||There is no error msg, it just doesn't change the database path at all. The path is accessible by crystal because data for the temp table reports are in a folder 1 below the main folder and most of the time they seem to work.

Thanks
Daryl...

No comments:

Post a Comment