prabha_friend
Prabhakaran Karuppaih
- Local time
- Today, 19:35
- Joined
- Mar 22, 2009
- Messages
- 771
"The Datatype from Hell"
Hello All!First I want to confess that I am not a professional Access DBA or a VBA Developer. I am just a curious amateur who wants to spend his time someway useful. Currently I am exploring the OLE Datatype in an access environment. I wonder why this Datatype is much complex to understand. My exploration was very smooth until I approached programmatically. First, I cannot able to store OLE data like any other data in a normal access recordset (DAO). Secondly, I fear If I am having this much difficulty in dealing with this Datatype in a single application (Access) how am I goanna automate cross applications (Access and Excel). I did some search in internet regarding this. What I found so far is not fruitful either. To say frankly, those are too much advanced to a beginner like me. I swear I never found an article which starts from the origin like what is OLE Datatype? In what ways it differ from other datatypes? Why we are not getting it stored in a Recordset? If possible how it is taking cared in DAO and ADO models? I believe you understand the need of all amateurs like me to evolve and I expect you all people here will do the needful.
P.S:
Before a month, I asked same kind of help for MSDE. I cannot forget the supports our members gave me here. Now situation is so much improved in MSDE for me. I am also deciding to write an article about MSDE sooner. If I do, definitely It will be a dedication to you all.