S
S N
Is it possible to store images inside an Access database?
If so how?
If so how?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
R
Roger Carlson
Although is is *possible* store images in OLE object in Access it is
generally discouraged. It bloats the database very quickly and I suspect
would make the database more prone to corruption much like Memo fields.
The usual solution is to leave the pictures in a directory on your hard
drive, store the path and filename in a record in the database, and just
*display* the images in an Image control on a form or report.
On my website (see sig below) is a small sample database called
"Pictures.mdb" which illustrates this process.
generally discouraged. It bloats the database very quickly and I suspect
would make the database more prone to corruption much like Memo fields.
The usual solution is to leave the pictures in a directory on your hard
drive, store the path and filename in a record in the database, and just
*display* the images in an Image control on a form or report.
On my website (see sig below) is a small sample database called
"Pictures.mdb" which illustrates this process.
G
Guest
Check out the Employees TABLE and FORM in the NorthWind
Traders database (comes with your copy of MS Access) to
see how images were included. This is a good example of
what Roger was explaining in his post.
Denny G.
Traders database (comes with your copy of MS Access) to
see how images were included. This is a good example of
what Roger was explaining in his post.
Denny G.
V
Val Mazur
Hi,
Yes, you can. See some examples how to do this. But you might get into the
issue, when your database will reach a limit on a size. Practice shows that
you cannot store big number of images because you will easy get 2M limit on
an Access database
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbpj01/html/gs0102.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;258038
http://support.microsoft.com/default.aspx?scid=kb;EN-US;194975
Yes, you can. See some examples how to do this. But you might get into the
issue, when your database will reach a limit on a size. Practice shows that
you cannot store big number of images because you will easy get 2M limit on
an Access database
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvbpj01/html/gs0102.asp
http://support.microsoft.com/default.aspx?scid=kb;en-us;258038
http://support.microsoft.com/default.aspx?scid=kb;EN-US;194975