Question about VB.net to access


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Question about VB.net to access

  1. #1
    Join Date
    Mar 2009
    Posts
    2

    Question about VB.net to access

    Hello,
    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.

    Sincerely,
    lmnorms

  2. #2
    Join Date
    Mar 2009
    Posts
    8

    Question?

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

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

    Thank you,
    Patrick.

  4. #4
    Join Date
    Mar 2009
    Posts
    8
    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 vb.net 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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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