How can I display long binary data in Microsoft Access Report

[Gevorg]

Hi Everybody!

I worked with my mdb file till its volume comes to 2GB.
I have table where the images are stored in OLE Object data type.
In previous I copied the images from Corel PhotoPaint and pasted directly into the table.


So I could work with my database report till the volumes comes to 2GB.

Please help me to understand what should I do to continue my job.

Thank you

George.

[June7]

Save the images in a folder outside the database. Store filepath to the image in table.

http://office.microsoft.com/en-us/ac...005280225.aspx

[Gevorg]

Thank you for taking time and responded to my question. The problem is that I prefer to use data management instead of file management, since the images are too many. They are about 1,000,000. For now they are 42,000. So this is the reason that I am trying to keep my approach in managing the images.

[June7]

If the images are bloating the file to exceed 2gb even after Compact & Repair, your options are multiple Access files or external storage of images. Or maybe convert to MySQL database.

What sizes are the images you are saving and what file type (jpg, tif, png, gif, bmp)?

[Gevorg]

I use jpg files in my tables for the images. I just upload images to MySQL table and linked to the table through Microsoft Access. Using LenB command for both columns I receive the following results: the file with long binary data in MySql have for example 44KB and in Access table have 2.2MB, the other one with 101kb have 4MB.
I am also interested in converting the files to Long Binary data to MySQL but I am not familiar with this operation. Is their any code which can convert the images to MySql table?

[June7]

I assume by your profile you are use Access 2000 and so must be using the OLE Object field type for your images. I don't know any code that can extract the image files from the table and 'move' into SQL. This link shows how to manipulate files from the Access 2007 Attachment field, maybe something similar can be done with OLE Object type http://blogs.office.com/b/microsoft-...cess-2007.aspx.

Google: access vba add delete copy ole object file

Maybe this can help

http://bytes.com/topic/access/answer...ject-ole-field