How to store Image / Picture in MS Access Database please send me source code to sajidmunsi@yahoo.co.in Pleaseeeeeeeeeee
2006-12-11 04:14:10 · 3 answers · asked by Sajid Munshi 1 in Computers & Internet ➔ Programming & Design
You cannot store the pictures directly in the access database. You can however link to the files. You should set up a folder to keep all of your pictures in then have Access link to the file name. You can link directly to the picture so you can bring the picture up on a form. You'll need to set it up as an OLE Object if you want to do that, but it will slow the speed of your database queries down significantly. Most programmers just do a text link to the file by storing the file directory path-name as text in the database.
2006-12-15 02:00:03 · answer #1 · answered by devilishblueyes 7 · 0⤊ 0⤋
you cannot do that in access. all u can do is save the picture in the hard drive and store the path of the picture in the Access DB. So that whenever u want to load the picture, you can get the path from the Access DB
2006-12-11 04:18:00 · answer #2 · answered by i_am_sami_da 2 · 0⤊ 1⤋
You can save it as a BLOB (binary large object).
2006-12-11 04:44:46 · answer #3 · answered by Jason C 2 · 1⤊ 0⤋