Connecting Tech Pros Worldwide Forums | Help | Site Map

Attaching Pictures to Record...Pls help

Femi
Guest
 
Posts: n/a
#1: Nov 12 '05
Hello all,

Please I need your help on this problem I'm having. I'm the database
administrator of my club and maintaining a database of members. I have
been adding the passport photo of members to their record but the size
of the databse grow exponentially.

In fact, having a record of just above 250 is giving me a database of
size 120MB, Pls I can't continue like this. Need your help
Stuart MacKinnon
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Attaching Pictures to Record...Pls help


febad@tiscali.co.uk (Femi) wrote in message news:<7c47149.0311250555.775657e1@posting.google.c om>...[color=blue]
> Hello all,
>
> Please I need your help on this problem I'm having. I'm the database
> administrator of my club and maintaining a database of members. I have
> been adding the passport photo of members to their record but the size
> of the databse grow exponentially.
>
> In fact, having a record of just above 250 is giving me a database of
> size 120MB, Pls I can't continue like this. Need your help[/color]

Hi,

An alternative is to link to the images rather than store them in the
database itself.

There are numerous explanations/discussions to be found if you search
Access groups from here:
http://groups.google.com/advanced_group_search

Larry Linson's site has some examples of ways to deal with images:
http://accdevel.tripod.com/ (See his "Imaging Examples"). See also
Stephen Lebans' site: http://www.lebans.com/

Best wishes
Stuart
Closed Thread