Hi Lalit

According to my knowledge u can store images in the

database by the datatye of the field as "OLE Object"

But this sometimes creates a problem

Even in database like oracle "Blob" or "Image" in SQL

Server creates problem sometimes 

So the better solution usually followed for this is

that, we generally store all the related images in

some folder and then sotre THE PARTICULAR PATH as some

field (say ImagePath Varchar(50)) in the database

In this way we even give user, the flexibility of

saving into his choice folder and in the same time we

do not burden the database with large datatypes and

hence size

Because if in due course of time if ur database

increases then u find that even for simple queries for

that table it takes a lot of time



I hope this suggestion is valid for u

bye

thanks

Krishna





__________________________________________________

Do You Yahoo!?

Buy the perfect holiday gifts at Yahoo! Shopping.

http://shopping.yahoo.com

> Hi I am trying to update image field in access database.

> I am new to this so cant able to do that.

> Need help

> Thanx.

> Lalit

My requirement is specific to saving Image in database.

So saving it on local storage wont solve problem.

How to stream it to server.

Lalit





> Hi I am trying to update image field in access database.

> I am new to this so cant able to do that.

> Need help

> Thanx.

> Lalit