PDA

Click to See Complete Forum and Search --> : How to store graphics (bmps etc. )files in VB/MSACCESS


aamer
Jul 30th, 1999, 05:53 PM
How can I store graphics files (BMPs etc.) in VB with MSACCESS database.

ajeetc
Jul 30th, 1999, 09:03 PM
though it possible to do that it is better to store the path in the database. this ensures that the database file size is manageable and the graphics can be stored in a separate sub-directory.

Cheers

ajeet

SmithVoice
Aug 4th, 1999, 11:42 AM
I agree that "it is best" to not actually put a lot of graphics or other binaries into a physical database however there are times when it is very helpful. To see a simple step by step demonstration (plus a demo of how to have any graphic retain it's aspect ratio within a defined area ... great for printing thumbnails and letting users add their own logos to your multiuser database apps) click over to:
http://www.smithvoice.com/appendin.htm

It's the same deal if you want to add graphics, wavs, avis or any other binary files ... I use this same method and some repolication code to keep all of my ocx and program patches in a searchable jet database spread across multiple zip disks.