Discussion Locked

Access 2002 File Size Limit

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Is there a file size limit in Access 2002.

In Access 2000, there is a limit of 2Gb. Has this been removed?

What are the options for the database engines (Jet, MSDE) and do they affect the size limits

7 replies

by peter ritchie

In Access 2000 there is a file size limit of 2BG per MDB file. This is not a limit of database size. Because you can link tables in another mdb file you effectively have not size limit per database.

It would appear that Microsoft has not changed the 2GB MDB file limit.

Jet is simply the engine behind Access--so, it has the same limits. MSDE uses the SQL Server engine so there are no limits to the size of a database with MSDE.

by maxwell edison

I believe that the operating system will have as much - or more - to do with the maximum file size as the application will.

See the following Microsoft article on that subject:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;q237740

http://www.microsoft.com/mspress/books/sampchap/5205c.asp

(REMOVE SPACES from the pasted URLs.)

I believe that with Access XP (2002) running on Windows XP there is no limit to the file size - assuming hardware and configuration settings allow it.

Maxwell

This discussion is closed to new replies.