DB Max Size

[JF Bouthillier]

Hi all,

I have to build a database that will contain 120,000
entries. What are my options to try to minimize the size
of the database (I don't have an SQL server)? At what
point will the performance be affected?

Thank you.
JF

 

[Joseph Meehan]

Hi all,

I have to build a database that will contain 120,000
entries. What are my options to try to minimize the size
of the database (I don't have an SQL server)? At what
point will the performance be affected?

Thank you.
JF

120,000 records is not all that big. Access can go to one or two Gig in
total size. The number of records is not really a good measure of what the
performance will be. The overall design is very important. Queries, forms
reports table construction, indexes, field types and sizes etc. all enter
into the total.

Do look into normalizing the data. Construct the tables carefully and
choose filed types carefully. Be sure to compact the database from time to
time.

It really requires a very good knowledge of the information, how it is
collected, who is working with it, what will be done with it, and some good
guesses about what may be needed in the future is needed to design well.

 

[Marin Kostov]

Open Access; Press F1, and find the topic "Getting Started". There is a
sub-topic "Microsoft Access Specifications".
Most ant the answers are "by the spring" - The online help.
For your database to work better, try to normalize it. Here on that board
are tips how to do that and why it is good to be done. Next, split the
database in front-end and back-end. There is a tool to accomplish that task.
And it is good idea to compact and repair the database from time to time.
If you feel that your db is not performing well, just make several db's and
link the tables in the main one.