size of database

S

Squibbly

how big can a database go up to, i have 1 that is currently 40Mb, would i
need to make a new database soon??
 
L

Lynn Trapp

You have a long way to go yet. The maximum size of an Access 2000, or later,
file is 2GB (for A97 and earlier it's 1GB).
 
J

John Vinson

how big can a database go up to, i have 1 that is currently 40Mb, would i
need to make a new database soon??
Click to expand...

Are you regularly Compacting (tools... database utilities... compact
and repair)?

If so, you can store fifty times as much data as you currently have
before you hit the 2GByte (2048 MByte) size limit.

If not... do so; and you'll be able to store even more.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Export to PDF 0
Access Lock File .LACCDB / Now shows as a notepad file 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
How can the font and size of (all) citation numbers be altered? 1
Text in note pane of "normal" display suddenly much larger 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Using Access Database to build contracts with fields on pdf document 0
Merging from an Excel file with graphics 1

Top