Hello
I have MS Access Work Management Program, this is a Client (MS Access 2010) Server (SQL 2012 Express - hosted on Windows 2012 Standards Server) solution. being in use for 3 years successfully.
There are 10 users using this application, users are connected to the sever via Remote Desktop Connection, and carryout their day-to-day activities.
The Work Orders are issued as per following:
1- Run the Run-sheet report and output it pdf file and save it in temp folder
2- Run the individual Work Order Reports (as listed in the Runsheet) and output each report to PDF, and save it in the temp folder
3- Merge the all the WO pdf files into the Runsheet
4- Attach the merged PDF file to an email and send it to the work crew
5- Clean up temp folder
All was working well, until Tuesday 08-04-2014, all users when trying to issue the work orders (following the automated process above) it came up with Error saying: "Microsoft Access has stopped working" and gives options to check on line (which finds nothing), restart, or debug.
the details of the error message is:
=====
Problem signature:
Problem Event Name: BEX
Application Name: MSACCESS.EXE
Application Version: 14.0.7104.5000
Application Timestamp: 51ce12f7
Fault Module Name: MSVCR90.dll
Fault Module Version: 9.0.30729.6871
Fault Module Timestamp: 4fee6073
Exception Offset: 0006ccd5
Exception Code: c0000417
Exception Data: 00000000
OS Version: 6.2.9200.2.0.0.272.7
Locale ID: 3081
======
Steps performed:
1- There is no modifications/updates/deletion happened on the Windows Server 2012
2- The Same function that produces WO package, it produces the Invoicing Package (Statement, and Invoices), and this is working properly :banghead:
3- I copied the application to Windows 8 machine it worked properly.
The system is failing on the following line:
DoCmd.OpenReport stDoc, acViewPreview, , stLink, acHidden
Reports!rpt_WO.Visible = False
DoCmd.OutputTo acOutputReport, stDoc, acFormatPDF, stFileName, False
DoCmd.Close acReport, stDoc
4- i have checked the DEP setting and created excluded office 2010.
All the above did not resolve the issue .... Please Help,.....?????
I have MS Access Work Management Program, this is a Client (MS Access 2010) Server (SQL 2012 Express - hosted on Windows 2012 Standards Server) solution. being in use for 3 years successfully.
There are 10 users using this application, users are connected to the sever via Remote Desktop Connection, and carryout their day-to-day activities.
The Work Orders are issued as per following:
1- Run the Run-sheet report and output it pdf file and save it in temp folder
2- Run the individual Work Order Reports (as listed in the Runsheet) and output each report to PDF, and save it in the temp folder
3- Merge the all the WO pdf files into the Runsheet
4- Attach the merged PDF file to an email and send it to the work crew
5- Clean up temp folder
All was working well, until Tuesday 08-04-2014, all users when trying to issue the work orders (following the automated process above) it came up with Error saying: "Microsoft Access has stopped working" and gives options to check on line (which finds nothing), restart, or debug.
the details of the error message is:
=====
Problem signature:
Problem Event Name: BEX
Application Name: MSACCESS.EXE
Application Version: 14.0.7104.5000
Application Timestamp: 51ce12f7
Fault Module Name: MSVCR90.dll
Fault Module Version: 9.0.30729.6871
Fault Module Timestamp: 4fee6073
Exception Offset: 0006ccd5
Exception Code: c0000417
Exception Data: 00000000
OS Version: 6.2.9200.2.0.0.272.7
Locale ID: 3081
======
Steps performed:
1- There is no modifications/updates/deletion happened on the Windows Server 2012
2- The Same function that produces WO package, it produces the Invoicing Package (Statement, and Invoices), and this is working properly :banghead:
3- I copied the application to Windows 8 machine it worked properly.
The system is failing on the following line:
DoCmd.OpenReport stDoc, acViewPreview, , stLink, acHidden
Reports!rpt_WO.Visible = False
DoCmd.OutputTo acOutputReport, stDoc, acFormatPDF, stFileName, False
DoCmd.Close acReport, stDoc
4- i have checked the DEP setting and created excluded office 2010.
All the above did not resolve the issue .... Please Help,.....?????