Database Problems

  • Thread starter Thread starter Gary Botha
  • Start date Start date
G

Gary Botha

Hi, we have made a database that contains pictures with 1280 records, when
the database goes over 1.99 Gig, access goes into repair mode and we lose
everything, are the pictures causing the problem or is it file size? Please
help.
 
Gary Botha said:
Hi, we have made a database that contains pictures with 1280 records, when
the database goes over 1.99 Gig, access goes into repair mode and we lose
everything, are the pictures causing the problem or is it file size?
Please
help.
Click to expand...

Both. Maximum file size is being exceeded. Try linking your images instead
of embedding them. Compact/repair too.

Keith.
www.keithwilby.co.uk
 
Keith Wilby said:
Both. Maximum file size is being exceeded. Try linking your images instead
of embedding them. Compact/repair too.

Keith.
www.keithwilby.co.uk
Click to expand...
Hi Keith,

Thanks for your response. I am giving this database to a client, must I
first add the pictures to a folder, link them to the database and then supply
the database and the picture folder to the client for the database to work
properly?

Regards
Gary
 
that's what I'd do. it's a pain but pro'ly easier than compressing the pics
down to a small size, if that's an option, unless you have a batch proc photo
manager. U using A2007? I haven't tried it but A2007 is supposedly better
at formatting pics in jpg or png format. If you're using an earlier Access
then try smaller pics and convert them to .bmp format. You may get away with
a pic size of around ~250 pixels @72dpi, depending on what you're viewing.
 
Thanks for the info Maarkr,

Regards
Gary

Maarkr said:
that's what I'd do. it's a pain but pro'ly easier than compressing the pics
down to a small size, if that's an option, unless you have a batch proc photo
manager. U using A2007? I haven't tried it but A2007 is supposedly better
at formatting pics in jpg or png format. If you're using an earlier Access
then try smaller pics and convert them to .bmp format. You may get away with
a pic size of around ~250 pixels @72dpi, depending on what you're viewing.
Click to expand...
 
Back
Top