W
wherewasi
Guest
Hi,
I have an application (VB6) that writes to a MS Access 97 DB over an ethernet connection using ADO. The app kicks-off Crystal Reports to print invoices etc. I am having a recurring problem and wanted to know if any of you have seen this before.
At Random, the length of text fields within the database gets changed to 255. I have no idea what the trigger for this is. It just 'happens' periodically. The effect of this change is to paralyze the Crystal report DLL... I get no output at all because Crystal thinks these are mis-used 'Memo' fields after the length-change.
It doesn't happen to just the temp tables that I'm writing reports to/from, either. It happens to static tables as well... reference tables that almost never get any data written to them.
Anybody have a clue...?
Tom
I have an application (VB6) that writes to a MS Access 97 DB over an ethernet connection using ADO. The app kicks-off Crystal Reports to print invoices etc. I am having a recurring problem and wanted to know if any of you have seen this before.
At Random, the length of text fields within the database gets changed to 255. I have no idea what the trigger for this is. It just 'happens' periodically. The effect of this change is to paralyze the Crystal report DLL... I get no output at all because Crystal thinks these are mis-used 'Memo' fields after the length-change.
It doesn't happen to just the temp tables that I'm writing reports to/from, either. It happens to static tables as well... reference tables that almost never get any data written to them.
Anybody have a clue...?
Tom
