Memos & Images in MS Access?

Posted on 2005-04-11
Last Modified: 2010-04-05
Using Delphi 7, MS ACCESS  & ADO ( using No Data aware controls at all)

I have two Memo (memShortDesc, memLongDesc)

I need to be able to do a Insert and place the lines from my memos into the table's fields  (ShortDesc, LongDesc) - Note : fields are of type Memo
I also need to be able to retrieve memo lines from table and plave in Memo controls.

I also have 1 Image  (imgMain)

I need to be able to do a Insert and place the image (bitmap)  into the table's field (Image) Note : field  is of type OLE Object
I also need to be able to retrieve the bitmap from the table and place in image control

How do I do this?

Question by:IElite
    1 Comment
    LVL 27

    Accepted Solution

    as loas as you don't need to access the fields with the access frontend,
    you can store your image like

    TBlobField(Dataset.FieldByName('Image')).LoadFromFile(FileName);// or loadfromstream

    TBlobField(Dataset.FieldByName('Image')).SaveToFile(FileName);// or SaveToStream

    similar you can work with your memos.
    in case of memos you could also use the dbaware-component TDBMemo

    meikl ;-)

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
    Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now