Solved

problem writing exceptions to Access

Posted on 2004-09-10
3
193 Views
Last Modified: 2010-04-15
Hi,

I'm trying to nail down a bug which has been nagging me, so I decided to log any and all exceptions to Access.  Trouble is that I can't seem to get a Memo field to accept the exception, which is chocked filled of special characters.

Any ideas about how to get such a chunk of text into Access?  Or if you know any other way to accomplish my goal of logging an exception, I'd really appreciate it.


Thanks,
Bob
0
Comment
Question by:ba272
3 Comments
 
LVL 20

Expert Comment

by:TheAvenger
ID: 12025666
Do you want to log only the message? If so, you can use a simple Text field. It takes less memory and is much easier to handle. Just make its size 255 (I think this is the maximum) and you will be able to save at least 99.99% of the messages (the other 0.01% will be too long and will be cut)
0
 
LVL 8

Accepted Solution

by:
Razzie_ earned 500 total points
ID: 12026597
'which is chocked filled of special characters.'. Are you saving the Exception.Message and not trying to save the Exception object itself?
0
 

Author Comment

by:ba272
ID: 12027734
Thanks.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In order to hide the "ugly" records selectors (triangles) in the rowheaders, here are some suggestions. Microsoft doesn't have a direct method/property to do it. You can only hide the rowheader column. First solution, the easy way The first sol…
We all know that functional code is the leg that any good program stands on when it comes right down to it, however, if your program lacks a good user interface your product may not have the appeal needed to keep your customers happy. This issue can…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question