Database Size

[Crispy]

I have just realised, after lots of Data Entry, that an individual database
is restricted to 2Gig! I actually need more...

Is there a way round this, and does anyone know why there is this limit?

Thanks

 

[John Vinson]

I have just realised, after lots of Data Entry, that an individual database
is restricted to 2Gig! I actually need more...

Is there a way round this, and does anyone know why there is this limit?

Not within Access, no.

2 GByte is an ENORMOUS amount of data. Are you Compacting your
database regularly? Does it contain graphical images (which are
handled very inefficiently, and should not be stored in tables as a
rule)? Or do you really have over a million records of a kilobyte
each? Somebody's been doing a LOT of keyboarding if so!

 

[Crispy]

It is enormous - There are graphical images - But they are "linked: to
record album covers - Not embedded. So the images are on the hard disc, not
the database

There happens to be about 1500 albums, all with Artist, Album, cover pic,
track details, general info like media type etc etc.....It soon mounts up..!

I still don't understand why there is a limit..?

Regards

 

[Exponent]

Actually, even OLE linking can cause a massive storage overhead, since an uncompressed bitmap is sometimes
stored in the database. You should consider storing only the filename in a text field and displaying the
image in an image control.

Your database should then only require a few MB, and your album collection will have quite some way to
grow before the limit becomes remotely relevant.

Note that there are a few workarounds that may be required for the Access Image Control (scroll-too-quick
crash, progress dialog supression) - see http://www.mvps.org/access/toc.htm for more info. Also, note
that the relevant office graphics filters are required to display the images.
--
_______________________________________________________
http://www.ammara.com/
Image Handling Components, Samples, Solutions and Info
DBPix 2.0 - lossless jpeg rotation, EXIF, asynchronous