i want to store jpeg pictures in an access database without converting it to bitmap picture. because bitmap pictures is very larger than jpeg picture so my database becomes very large and unmanagable and hard to distribute.I prefer working in visual basic. so can you hint me ,how can i store jpeg pictures in access databses without converting it to bitmap in visual basic ?
thank you in advance.

Wow, ambitious... umm, you could read in the binary jpeg, and them insert it into your database, then read it out and write it as binary back to the file.

I don't know how Access handles what tend to be called BLOB's (binary large objects) in RDB circles, but I think he needs more information than that, gian.

You can store jpgs as an OLE object. You need to create a OLE object field in your table and then when you insert object you should pick the most common media viewer that you have(this is so that other people will have it, i choose Microsoft photo editor). Then the rest is self explanatory. You can choose between existing file or create a new file and some other things too. I know this works in Access 97 and 2000. If you need any more help or an example e-mail me and I will send you one.

Sorry... I'm not really a VB programmer, or really a heavy access user.