Access XP db file size limit??

[Jignesh Bhakta]

Hi,

Does anyone know if Access 2002 (XP) databases have a file
size limit?? I heard somewhere that either Access 2000 or
2002 databases have a filesize limit of 2GB and was
wondering in what version that was true in and if
Microsoft have removed that restriction.

THanks,

Jignesh.

 

[Cheryl Fischer]

The single-database file limit is 2GB for Access 2000 and newer; 1GB for
Access 97 and older.

 

[Kevin3NF]

2000 and newer have 2gb limit. 97 was 1gb.

See specifications in Access help for more info

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

 

[Jignesh]

Thanks,

Jignesh.

-----Original Message-----
The single-database file limit is 2GB for Access 2000 and newer; 1GB for
Access 97 and older.

--

Cheryl Fischer, MVP Microsoft Access






.