Access file size???

[Darryn Ross]

Hi...

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

thanks

 

[dlw]

1 gig
(I think)

 

[david epsom dot com dot au]

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

 

[John Vinson]

Hi...

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

thanks

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.