Insert a draw in a field of table

[Magaly Sifuentes]

I need create a table, but i don´t know which kind of field may I have to
create. to insert a draw or some picture.

 

[thomp]

Magaly,

You can put a picture in a form, report or data access page, but not a table.

Hope this helps

 

[Tim Ferguson]

"=?Utf-8?B?TWFnYWx5IFNpZnVlbnRlcw==?=" <Magaly
(e-mail address removed)> wrote in

I need create a table, but i don¶ït know which kind of field may I
have to create. to insert a draw or some picture.

The OLE field was invented for this; but it's a Really Bad solution. The
OLE storage type uses huge amounts of room for its display functionality,
so a database starts to head up to the 2GB limit after a few hundred rows.

The best alternative is to keep the pictures on disk, and store the path +
filename information in the database. See the Access Web
<http://www.mvps.org/access> for more details.

An alternative is to roll your own BLOB field: see
<http://support.microsoft.com/default.aspx?scid=kb;en-us;210486>


Hope that helps


Tim F