Question about to access

DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Question about to access

  1. #1
    Join Date
    Mar 2009

    Question about to access

    I currently have a VB.Net program that connects to a excel workbook.
    Works great locally but when I run a time triggered scheduled job through report manager on the server; I get an error. The error is:

    ComException (0x800A03EC) "FilePath\File" Could not open excel or File path not found.

    I also get a similar issue with Win automation and a triggered task.

    I understand that this is a common exception for running the
    Interop.Excel. I believe this has something to do with the security permissions that the program receives in running under a scheduled tasks instead of an actual user id.

    My questions are:
    1. Can this error be fixed? I have not found any research that
    supports this. If so, How?

    Thank you in advance for your comments. I apologized if this is the wrong forum for this question, I didn't know where else to put this topic.


  2. #2
    Join Date
    Mar 2009


    How are you starting it? Is it from a Scheduled Task or service?

  3. #3
    Join Date
    Mar 2009
    It is running as a scheduled task in Report manager of SQL server 2005.

    Thank you,

  4. #4
    Join Date
    Mar 2009
    Is it possible to run is as a windows scheduled task?

Similar Threads

  1. VB.Net writing to MS Access
    By Force in forum .NET
    Replies: 9
    Last Post: 04-25-2008, 12:40 PM
  2. Amateur Question on Access VBA
    By Gliff in forum VB Classic
    Replies: 3
    Last Post: 12-16-2007, 04:03 PM
  3. ms access database question using 2003
    By trains58554 in forum Database
    Replies: 3
    Last Post: 10-27-2007, 07:00 AM
  4. Access printout question. A new user.
    By alaska_eric in forum VB Classic
    Replies: 1
    Last Post: 03-15-2005, 05:31 PM
  5. VB over Access question
    By thomas555 in forum VB Classic
    Replies: 1
    Last Post: 08-31-2002, 07:15 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center