Microsoft Access A to Z: Storing and displaying images in your database
HTML-код
- Опубликовано: 8 фев 2025
- This short screencast describes how to store and display images in your Microsoft Access database.
See all of my RUclipss organized at learncs.w3spaces.com
Thanks, Lisa Friedrichsen
![Microsoft Access - Tutorial for Beginners in 12 MINS! [ + AI USE ]](/img/1.gif)
Thanks
You are very welcome. See all of my RUclipss organized at learncs.w3spaces.com
@@lfriedrichsen i was taking about bitmap image in side of attachment in access how to add it there is no video or guide for it in 2007 ms access
Thanks for sharing
You're welcome! See all of my RUclipss organized at learncs.w3spaces.com
Does this field uses the storage size of the Access database or does it use another way to store the files so that the database storage will not get consumed so fast? I understand that the maximum size of an Access database is just like 2Gb
@@beholderer yes the Attachment field data type works as if it stores the file directly within the .accdb database file. If you have so many pictures that you would push to the maximum access database file size, then you might go with the Hyperlink data type which only stores a path to the file.
@@lfriedrichsen Can this be done in such a way that the image is still displayed within the access form (as opposed to an icon or hyperlink)? For example, could I maintain a directory of images that the DB could access and display in the Access form? We're attempting to create a new parts inventory system for my father and right now all the data is in Excel and jpg images, but the images would exceed the 2GB cap quite handily.
Some thoughts --
1. Would very low quality .jpg images be acceptable? If so, you store the .jpg images in an Attachment field data type. That would be very straight forward and simple. Often, pictures we take with our cameras and phones are at a much higher quality than needed for viewing on a screen.
2. If you stored the .jpg images in another folder and used the Hyperlink data type to store the path to the file all it would take is another click on the form or report to open that Hyperlink which would bring up that image.
3. One time I worked with images in a database that we only needed for a short period of time. So we inserted them in the database using the Attachment field data type so we could run our reports, but then ran a macro each Friday that deleted older images we didn't need any more. (We also had the images stored in an external folder just in case we needed to insert them into the database again). I don't think this sounds like it would be your best option, but sometimes these types of ideas are helpful too. Best wishes!
Can you print a report with an Attached file (jpg) with the preview of the file as appears in the table? Or is mandatory to be Bitmap OLE object?
@@zeblock a jpg image will print very nicely from a form or report
@@lfriedrichsen hmmmmm i just cant find the way how to make it in a report form...the attached file field is not shown as an option for the report
@@lfriedrichsen Maybe you could show us in a new video?🥰🥰
A .jpg file in an Attachment field can/will show up on either a form or a report, but it sounds like your problem may be that you do not know how to add new fields to an existing report. Try starting with the Report Wizard, and then choosing the fields you want on that report including the Attachment field that contains your .jpg. That will create a starting report that shows the .jpg file that you can modify later as needed.
how can i add bitmap image in the table having datatype image
Well there is no image Data Type but you can add any type of file such as a .jpg file to a field with an Attachment Data Type.
Dear prof I took introduction to computing class here in Toronto from centennial college and we used your Illustrated Microsoft®Office 365 & Office 2019 Advanced Book. I found it efficient to learn microsoft office through mindtap. Since I already graduated and don't have access to course key , wasn't able to access mindtap part even though I recently bought the book through cengage. Please help me as I have computer assessment test at my job for my promotion. Any help would mean a lot.
Mindtap is a Cengage product so I'd start by calling their customer support line to get a course key to Mindtap, given you already purchased the book through Cengage. A second idea is that although you have already graduated, the professor for your Intro to Computing class might also be able to help you depending on how electronic textbooks are sold to students at your previous school.
@@lfriedrichsen I did tried both option. 😞
@@serenela950 Then it sounds like you did not buy the version of the textbook from Cengage that includes the MindTap course key. You'll have to take this up with Cengage for answers. They control the course keys to their MindTap product and distribute them to school bookstores as needed. I don't have anything to do with that.
@@serenela950 PS: My understanding of MindTap is that it is merely an interface to various textbooks and resources from Cengage. If what you really want is to learn Microsoft Office and/or Microsoft Access, just work through the exercises in the textbook!
@@lfriedrichsen I did buy the mindtap version online through cengage. it allowed me access to the book but it asked for course key for mindtap. My understanding was mindtap access is access to particular class (virtual in this case) but since i am not student anymore, I dont have a class so when i emailed prof, she said its only for student. Its such small thing for prof but it could mean so much to me. I learned through mindtap so easily so was hoping I could learn through it again. Anyways I will go college bookstore and see if that access will allow me. Thank you Prof Friedrichsen for replying.