Max. size of .mdb?

[Crystal Lin]

Does any know the max. size of a .mdb file?

Thanks in advance!


Crystal

 

[Graham R Seach]

Crystal,

Access 97 (and prior, I think) - 1GB
Access 2000 and above - 2GB

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Tony Toews]

Access 97 (and prior, I think) - 1GB

Correct.

Tony

 

[Crystal Lin]

Thanks All! ^0^
Crystal

Crystal,

Check out 'Specifications' in ACCES Help. This will tell you max size of fields, Memo fields, etc.

John Parkinson