file size limit

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

is there a size limit for files within Access 2002, or a
total database size limit? I am developing a base for a
large photo archive and need to know the specifics.
 
Mike said:
is there a size limit for files within Access 2002, or a
total database size limit? I am developing a base for a
large photo archive and need to know the specifics.
Click to expand...

The limit for Access 2002 is 2 GB, but you may run into difficulty with more
than a few users way before that limit. Actually you are limited to about
500 GBs because you can connect a single 2 GB table in each of 255
databases. All that is theory though.

If you store your images in external files and use only linked paths to them
(a practice I recommend) you can store quite a few paths in a database (well
over a million). Look at the PictureMgr database on my website for the code
samples on how to do it:

http://www.datastrat.com/Download/Picture2K.zip

OTOH, if you store the images inside the database, you can store only a few
thousand and you'll have a greater chance of corrupting one or more records
if there is a failure during a write operation.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top