Database Problems

[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.

 

[Keith Wilby]

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.

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

Keith.
www.keithwilby.co.uk

 

[Gary Botha]

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

Keith.
www.keithwilby.co.uk

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

 

[Maarkr]

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.

 

[Gary Botha]

Thanks for the info Maarkr,

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.

 

[Fred]

If you the "downsize" route, BIMP Lite is a good free bulk image processing
program.