Certain Reports Crashing on ImpUser due to function

[navshiv]

I created some reports so that users can run these in the Impromptu User as these reports have prompts. These reports work fine on everyone's PC apart from one person. He has exactly the same version of Impromptu than everyone else and uses the same ODBC DSN settings to the MS Access database to everyone.

He is able to connect to the database when logging on to the catalog but he has the problem when the report opens. The report opens and asks for a date to search on (dd/mm/yyyy) but when we enter any date an application error occurs saying that the memory could not be read. We have re-installed the software but no luck. We have checked settings like date/time settings, network security, and catalog access rights but all looks fine here. I have also renamed his impromptu.ini and asked him to run the report again but this did not resolve it.

The strange thing is that it is just one user has the problem on the same reports at the same point when opening.

I found that the reports that crashed contained functions such as substring in calculated fields. I have tried creating a really simple calculated field using the substring function and this crashed the application.

I found that his MS Access ODBC version was 4.00.5303.01 which was different to other people so I changed his to the same as theirs (4.00.3711.08) and this still did not work. He is using Win NT4, Imp User 6. We have also tried newer and older version of the driver but still no luck.

any ideas?

 

[CosmicNerd]

Presumably you've tested whether it's the machine or the user that's causing the problem, ie can this user access the report on someone else's machine?

I suspect that person has a memory fault on their PC. Impromptu uses a lot of memory. Have you looked in the task manager under NT4 to see what resources he's using and then compared that to other users?