Error while opening Excel report from Visual basic 6.0

[ourspt]

Hi,

We have a problem in our application that uses Visual Basic 6.0 on SQL Sever
database which runs on Windows 2003 O/S. It uses server side COM plus
components and the reports which are generating from the application are in
MS Excel.

The client application is installed on a Terminal Server machine that runs
Windows 2000 O/S.

When we try to access some of the excel reports, generated excel file opens
alright in a different window but the actual client application is
terminating/crashing.

I found Drwtsn32.exe in process list of task manager, just before the
application terminates, and after termination of the application, this
file(Drwtsn32.exe) doesn't exist in the task list.

This message pops up on the screen, before the application is closed.

"abc.exe has generated errors and will be closed by windows. You will need
to restart the program. An error log is being created."

The following content is written to Drwtsn.log file and I found the
following error:

Application exception occurred:
App: (pid=1065)
When: 1/7/2005 @ 21:25:26.985
Exception number: c0000005 (access violation)

Any help in this regard is greatly appreciated.

Thanks in advance
ourspt

 

[Beth Melton]

If you don't get the answer you are looking for here you might try
posting your question in one of the Office developers newsgroups since
that's where the VB/VBA experts tend to hang out.

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/