Finding size of database

[teser3]

I keep reading that Access 2000 has a maximum size of 2 GB.

Is that the file size of the database? Or how can I tell what the
exact size is of my Access 2000 database? Also how do I count my
objects in the database because I hear there is a max for objects also.

I am using a web front end to populate and search the database and do
not have any delete capability.

Right now my database file size shows 1 MB and I have 4 relational
tables in it with around 500 records.

 

[John Vinson]

I keep reading that Access 2000 has a maximum size of 2 GB.

Is that the file size of the database?
Yes.

Or how can I tell what the
exact size is of my Access 2000 database? Also how do I count my
objects in the database because I hear there is a max for objects also.

By "objects" this means the count of Tables, Forms, Reports, Queries
and other stored objects. It does NOT mean that there is a limit on
the number of records you can store in the database - other than the
2GByte limit there is none.

I am using a web front end to populate and search the database and do
not have any delete capability.

Ummm... Why not? If it's a .mdb file you can open it in Access and do
anything you want. Just because it *has* a web interface does not mean
that you are limited to using only the web interface.

Right now my database file size shows 1 MB and I have 4 relational
tables in it with around 500 records.

In that case you have approximately 1998 MByte to go before you hit
the wall; you can make this database about 1500 times as large as it
is now before you even need to start thinking about redesign. 1 MByte
is TINY.

It would be prudent to use Tools... Database Utilities... Compact and
Repair periodically, just to keep it cleaned up and efficient.

John W. Vinson[MVP]

 

[teser3]

Thanks!

By "objects" this means the count of Tables, Forms, Reports, Queries
and other stored objects. It does NOT mean that there is a limit on
the number of records you can store in the database - other than the
2GByte limit there is none.


Ummm... Why not? If it's a .mdb file you can open it in Access and do
anything you want. Just because it *has* a web interface does not mean
that you are limited to using only the web interface.


In that case you have approximately 1998 MByte to go before you hit
the wall; you can make this database about 1500 times as large as it
is now before you even need to start thinking about redesign. 1 MByte
is TINY.

It would be prudent to use Tools... Database Utilities... Compact and
Repair periodically, just to keep it cleaned up and efficient.

John W. Vinson[MVP]