By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,899 Members | 1,190 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,899 IT Pros & Developers. It's quick & easy.

Exception from HRESULT: 0x800A9D9F

Malathi
P: 31
Hi,

Im opening an accessdb(consists of forms,report,etc) via vb.net console application. This is for the purpose of scheduling jobs. Its working fine for hours. But if we are not logging in for 2 days the scheduler throws an exception as follows.
Exception from HRESULT: 0x800A9D9F
After logging in the error is disappearing. So I added the mdb into trust location but its of no use. I will be glad if anyone helps me.
Aug 29 '12 #1
Share this Question
Share on Google+
8 Replies


TheSmileyCoder
Expert Mod 100+
P: 2,321
You will need to show us the code you are using, and indicating the line which fails.
Aug 29 '12 #2

Malathi
P: 31
Thanks for your reply smileycoder. Actually its happening at the run time, that too login issue. i.e. When the scheduling starts this app works fine, but if we are not logging for days then its throwing the above exception. If we do login again to the scheduler( by providing credentials)its working fine. This exception error disappears and continues the job as usual.
The model of the code Im using in vb.net console app is,
Expand|Select|Wrap|Line Numbers
  1. Private Sub RunAccessSub()  
  2. Dim appAccess As Object
  3.       ' Create instance of Access Application object.
  4.      appAccess = CreateObject("Access.Application")
  5.         ' Open WizCode database in Microsoft Access window.
  6.     appAccess.OpenCurrentDatabase "C:\My Documents\WizCode.mdb", False
  7.         ' Run Sub procedure.
  8.     appAccess.Run "Greeting", "Joe"
  9.     Set appAccess = Nothing
  10.     End Sub    
  11.  
Hope this gives you an idea.
Aug 29 '12 #3

TheSmileyCoder
Expert Mod 100+
P: 2,321
I dont really know what the exception is, and without real code to work with there really isn't anything I can do to help you. I don't know your setup, I dont know your access version, I don't know exactly what you mean by "logging in".

You do no provide nearly enough details to even guess where problems may arise.
Aug 29 '12 #4

zmbd
Expert Mod 5K+
P: 5,397
I think it has something to do with the .net framework throwing the error and not access.

If you are leaving a connection open to the .net for an extended idle time then there maybe a timeout on the connection thus a generic COM security error.

-z
Aug 29 '12 #5

zmbd
Expert Mod 5K+
P: 5,397
Yep,
This is a dot-net issue.. out of my knowledge base; however, here's a little information I read:
http://msdn.microsoft.com/en-us/libr...(v=vs.80).aspx
hopefully this will point you in the right direction.

-z
Aug 29 '12 #6

Malathi
P: 31
Ya.. I too feel the same while reading the link provided by you zmbd.. Here Im getting a perspective that this com exception is thrown because of access security? Or even if its within .net, what might be the solution? Do you have any idea?
Aug 30 '12 #7

zmbd
Expert Mod 5K+
P: 5,397
No; however, maybe moving this thread or reposting the question to the dot-net-framework forum may result in a better answer in that someone there has seen this...
-z
Aug 30 '12 #8

Malathi
P: 31
thanks zmcd.. I will move it .net forum!
Aug 30 '12 #9

Post your reply

Sign in to post your reply or Sign up for a free account.