Access 2002 File Size Limit
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
Web Development
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
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 pctune
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
by pctune
by pctune
This discussion is closed to new replies.
Sort by Trending