I`ve been using Crystal for 6 years in various roles and havn`t had any problems with it. I`m slightly biased as I worked for the company that produces it,...

Cheers guys, I actually did this a completly different way. I read the data into crystal reports, wrote a few formula`s then exported it to CSV and imported back...

I think you misread my posting.

I said I backed up the logs twice a day, that has no effect. Have tried shrinking manually, has no effect either.

It`s all in...

Do you mean just updating with data?

You`d just use a Stored Proc and an ADO connection client browser side (using commands to cal the stored proc).

Andy.

The servers got 2 GIG of memory, thats why I thought it would be ok to do it.

I`m going to put a list of recommendations together including some dedicated database...

I have stopped and started the server since.

THe log has been truncated, but I can`t shrink the damn thing!

Andy.

Use the OS command TEXTCOPY to get the graphics into the table. Crystal should be able to read them as long as they are bitmaps, jpegs or gifs.

I wrote...

Thats what I thought Andy.

However someone is trying to BCP this file back into a SQL Server 6.5 but getting errors on the dates unless they change the format??

Andy.

Touche....

Just found a util that decrypts the encrypted SP`s....heh....

Andy.

Cheers,

I`d thought about that, so I wrote 2 versions of this one that loaded everything at the start and then a load on demand. I suppose it`s got to...

Heres my code (you can probably see me building a treeview). I`ve thought about using the ListObjects method but can`t figure out the references....

---------------------------------------------

Private Sub cmdConnect_Click()

Tree1.Refresh

Tree1.Indentation = 3

...

I`m trying to restore from my backups! Thats just the problem. Incidentally, theres some sort of dual booting trickery to boot the machine into the old NT. ...

Everything seemed to be executing fine in the profile. I couldn`t be bothered doing any more testing, so I triggered the proc with a different ADO connection and connection...

already thought about that. I`ve given my application login rights to execute xp_cmdshell. When I log in query analyser can do it ok.

Andy.

I think the COALESCE worked guys! Thanks so much, that problems been bugging me for ages!!!

Thanks.

Andy.