DB Max Size

J

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
 
M

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.
 
Top