Maximum DB Size Access 2000

[Christopher Gilbert]

Does anyone know what the maximum total size of an Access
2000 DB is? At what point will queries run noticeably
slower? Where does the danger of data-corruption start?

 

[Lynn Trapp]

Does anyone know what the maximum total size of an Access 2000 DB is?

2 Gigabytes

At what point will queries run noticeably slower?

That depends on the database design and your hardware.

Where does the danger of data-corruption start?

From the minute you start developing the database, but this is true of any
system -- as soon as you start using it you run the risk of corruption. If
you will split your database into frontend/backend, however, you will lessen
the possibility of corruption.

 

[Roger Carlson]

The maximum size of an Access database can be found in the Hellp system
under "specifications".

As for the rest, there is no fixed number. It depends on:

For Speed:
1) number of concurrent users
2) network vs. local installation
3) network speed
4) number of indexes
5) composition of indexes
6) design of the application itself
7) how many of the "query optimization" techniques you use (you can find a
lot in ADH 2000 Vol 1)

For Corruption:
1) number of concurrent users
2) network vs. local installation
3) health of the network (my experience is that most corruption can be
traced back to network issues: bad NICs, routers, hubs, or segments)
4) data types used (specifically Memo and OLE fields are more susceptible to
corruption)

I'm probably missing some. Anybody?

 

[Guest]

Hi Christopher,

Total file size of a database should be 2GB incl. data, forms, pictures etc.
If you go to Access help and search for 'Specification' you will get an
overview of the limits.

In case you reach the file size limit, you will get an error message as far
as i know.
Due to that Access allocates additional space when
running(importing/calculating, etc. without giving the not needed space free
again, be sure to compact your database on a regular basis.

Bernd