size of database

  • Thread starter Thread starter Squibbly
  • Start date Start date
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??
 
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).
 
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.
 
ok thank you, i regularly use the compact and repair tool, thanks anyway
 
You must log in or register to reply here.

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

Graphics used as Backgrounds 1
emailing a large database - any extreme zip program out there? 9
What are the steps to fix damaged MDF files in SQL Server? 0
How do I invoice a cost to a custom built MS Access Accounting Database? 0
Access 2007 replica to master 4
What is this 40MB HDD worth? 9
register student to course 0
Excel Excel - Two Database Formula extraction? 3

Back
Top