Size Limitation

[Ashby]

Hello Everyone,

I am using an Access 97 database which contains over
11,000 records. Over 4,000 of these records contain
pictures of clients. Due to Access 97 size limitation of
1GB, no more pictures can be added. Could someone offer a
solution on how to resolve this problem.
Moving to Access 2000 or XP is not viable. Thank you.

 

[Mike Mueller]

: Hello Everyone,
:
: I am using an Access 97 database which contains over
: 11,000 records. Over 4,000 of these records contain
: pictures of clients. Due to Access 97 size limitation of
: 1GB, no more pictures can be added. Could someone offer a
: solution on how to resolve this problem.
: Moving to Access 2000 or XP is not viable. Thank you.

Use linked images instead of embedded. This will greatly
reduce the size of the database and make the database faster
all at once. You could also try to compact/repair the
database, it may allow a few more to be squeezed in.

 

[Applebaum]

Time consuming, but what if you moved the pictures somewhere else, and used
hyperlinks to link to them?

 

[Albert D. Kallal]

Without a doubt, the way to have designed this is to link to the pictures,
and not embed them into the database. 11,000 records is SO SMALL of a
database for ms-access. However, access does not store pictures correctly
when you use the ole approach.

Mostly likely, the total size of the data is 1, or 2 megs tops. That will
fit on a floppy disk!

Further, by embedding the pictures inside of the database, then stuff like
emailing the pictures, or even running your favourite picture editor like
paint shop pro, or whatever is hard. You can just use your favourite tool to
work, view or even edit/modify the pictures.

By moving out the pictures, then other applications, and other picture
editors etc can use the pictures with ease. As it is now, you have them
locked up in side a data file.

Linking pictures is the way to go. In fact, I have in the past had to fix
some very poorly designed databases that due to imbedded the pictures were
becoming useless.

The solution is link to the pictures placed in a directory.

check out:
http://www.mvps.org/access/forms/frm0030.htm