Improve company productivity with a Business Account.Sign Up

x
?
Solved

Access Long Binary Field to Display

Posted on 2013-02-04
5
Medium Priority
?
740 Views
Last Modified: 2013-03-13
Hi,
I have an Access file. It has been imported from the SQL file and it contains a long binary field, which was an image in SQL (stored in binary format). Now in Access I want to display this Long Binary field as a real picture what it should be.

How can I do this?

Sanjay.
0
Comment
Question by:Sanjay Gandhi
  • 2
  • 2
5 Comments
 
LVL 26

Expert Comment

by:jerryb30
ID: 38851452
Do you know its format? Can you post a sample?
0
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 2000 total points
ID: 38853834
0
 

Author Comment

by:Sanjay Gandhi
ID: 38863333
I am trying to send this Access file containing the JPEG image in the form of long binary. It is supposed to be a picture which I want to display in the Report.

I m trying, but the attachment is not attaching. It's a big file. I'll try again later.

Sanjay.
0
 
LVL 26

Expert Comment

by:jerryb30
ID: 38864283
How big?
0
 

Author Closing Comment

by:Sanjay Gandhi
ID: 38983681
Required a little more of tuning the code. Has helped finally. I was really late in responding though, owing to high travel and busy schedule. Thanks.
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
When we develop an application in Ms Access 2016 we should also try to protect the queries, macros and table links. I know I may not have a permanent solution but for novice users, they will not manage to break your application. Below is the detail …
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
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 …

606 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