Number of registers in access

[Eliot]

Hello all!!

I've got a question and I can't find the answer, hope you'll help me!!

I'm developing an application in access 2003, almost finish, and i'm not sure whether the application will be capable of keeping all the amount of data that will be inserted in it...

It will be about 4000 registers per month in one table, that is the biggest...

Will access be capable of handling with it?? How many data can access store as maximum???



God!! Hope will be ok!

 

[neileg]

There's a size limit of 2gb on the mdb file. if you need more than this, you can have multiple back end files each with a 2gb limit linked to a front end.

 

[GaryPanic]

should not be a problem
its not the number of records that count - its the format of the fields , etc

if you look at the difference between between a text field size and a memo size Access asigns space depending upon the field(format) itself even if you have let say 5 word in a memo field it will asign the full space for a memo field (something like 64,000 chars) compared to a txt field which is 255 ? - same with number fields some field will use more space than others

so you could have 200 records with a photo in each for example 100,000 in size with will blow your d/base to 2,000,000

or 2,000,000 records with just txt in them = 255 * 2,000,000.


then there is the use of archiving - how long is the data going to be need for
can you have 1 d/b per year
so
2007
2008
2009
failing this this there isa a free upgrade (which i have not used) which is ms sql express? which doubles the size to 4 thingameis - and allows a lot more concurrent users -(but thats a different question)

 

[neileg]

Gary, Access doesn't use empty space. If you have 5 characters in a field it stores 5 characters regardless of the field size being 255 or memo.

 

[GaryPanic]

Ah.. well you learn something new every day - i was under the impression that it reserved space according to the field format ...

 

[Guus2005]

Still, if you exceed the maximum limit of 2GB, store you data in another database like Oracle, MSSQL, MySQL, ... Link your tables to it and you can use your frontend whithout changing anything

Enjoy!