Student I-Card Printing Using Access ,VB and Crystal Report 8.5 and ADO

Posted on 2006-05-31
Last Modified: 2008-03-06
Respected Sir/Madam,

I am developing an application using Visual Basic 6.0 and MS-Access 2000, for Student I-Card Printing Using Crystal Report 8.5. I am accepting all Information from user including Student's Photo (May be JPG or BMP Format). I am not able to save and retrieve the Photo of student. I am using ADO and SQL To Insert and Update Data. Also the Photo should be printed in Crystal Report. Please Help me as the Project deadline is on Saturday 3rd June 2006.
Please do the needful ASAP.
Sandeep Bhambure
Question by:SandeepBhambure
    1 Comment
    LVL 58

    Accepted Solution

    Hello SandeepBhambure

    You can store the files in a special folder, and rename them using the student's ID numbers (that is what I would do) or include them as binary objects in your database. That means you will have to write them out to a temporary folder each time you need them.

    Here are two links for that method:

    ACC: Reading, Storing, & Writing Binary Large Objects (BLOBs)

    Jamie's Software - Access Articles
    Handling Images with Microsoft® Access

    Good luck!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

    760 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

    14 Experts available now in Live!

    Get 1:1 Help Now