Access file size???

  • Thread starter Thread starter Darryn Ross
  • Start date Start date
But you should aim to keep it below perhaps 750 MB

-- and you will find that a file that large takes
a long time to compact.

(david)

Hi...

Is there a max file size for access '97 databases??

thanks
 
Hi...

Is there a max file size for access '97 databases??

thanks
Click to expand...

1 GByte (1024 MByte). Tools... Database Utilities... Compact is vital;
if you're getting close to a gig, corruption becomes more of a risk.
Also, if you're storing graphical images in the database, consider
storing them as external files (and storing the path and filename in a
Text field) instead; or store them as BLOBs rather than images. Access
is HORRIBLY inefficient at storing graphics.
 
Back
Top