CAPACITY OF A *.MDB FILE

[selimsl]

Hi!
I use material.mdb file as my database,
and I add new records to my database every day,so
the size of material.mdb increases every day.
What is the capacity of a *.mdb file.What is the
maximum size of a *.mdb file before it is down.

Thanks in advice

 

[PHV]

Ask the help engine for limitations

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Trevil]

Do you ever perform a "Compact & Repair"? It is a good idea to do this on a regular basis ("regular" depends on how much / how often bloat occurs).

"Have a great day today and a better day tomorrow!

 

[JerryKlmns]

And a trick to bypass the limit:
In one mdb you can link tables of mdbs near the limit !

 

[Crowley16]

if you reach a point where limit needs to be considered then you should be using something else...

--------------------
Procrastinate Now!