Access Capacity (1 Viewer)

[jonamua1971]

hI
I JUST WANTED TO FIND OUT THE MAXIMUM CAPACITY OF THE ACCESS 2003 AND WHAT WOULD YOU ADVISE B/4 IT GET THERE. I HAVE A DATABASE AND I WOULD LIKE IT TO HOLD INFORMATION FOR AT LEAST 1YEAR 6 MONTHS
THANKS FOR YOUR RESPONSE IN ADVANCE

 

[RuralGuy]

Go into Access help and key in Specifications and then take your CAPS LOCK key off!

 

[jonamua1971]

Thank You For Your Quick Reponse

 

[RuralGuy]

Thanks for finding the Caps Lock key!

 

[jonamua1971]

access exams

Hi
i have been working on access for sometime now. i did first in college. is there anything else i can do to prove to employers that i done access
thanks

 

[The_Doc_Man]

Can't tell you how to prove you did. But here's a hint, and it actually happened here where I work.

Some doofus sent us a resume' in which he claimed that he had written this neat database for Access - and he called it the Northwind database.

From his description, it was the well-known sample database. He didn't get the job.

In general, for entry-level positions, it is enough to talk the talk and walk the walk to get hired. Making silly, disprovable, or impossible claims gets you a map to the nearest exit.

 

[GaryPanic]

Rural Guy - I keep seeing you in other posts - you don't half get around ..

J1971

Putting Caps lock on - and typing everything in Caps is considered to be Rude and will p*ss a lot of people off striaght away

right will access be big enough

its not time its quanity

its has a size limt of 2g (Tell me if I am wrong guys)
and it does depending on what you put in

I jused to use access as a brokering system and it held shit loads of records
with archiving it held 50K --60k records no problem at all
also how many users are going to use it Access states about 60 as a max
but I would have concerned if it was more than 35-40

Upsizing - Access from what I hear is realitively quiote easy (not done it my self - but have been told easy--ish) (but be careful of operating systems )

There are better options than Access - but you will pay more for them

you need to give a little more info than you have

I don't go to the doctor and ask him to fix me and not tell him whats wrong....

I think Access is pretty good their are enough people out there using it, I know lots of companies use it and even those who have bigger systems also use it form project that don't fit the system .....

Stability - dependes on how complicated and who writes it for you
easy of use - depends on what you want from it - if you get it built for you then you need to tell whoever excatly what you want - and not well this is what I said but i meant this - I would normally recomemend building a system yourself - or if you are te boss of a company - get the person who actual does the work to design it /build it

Does Access Crash yes 95% your can repair easily
other 5% other options are aviable - you can email over D/base to 3rd parties and they will repair - you can replace it with a backed up version (always do backup) you can import - old crashed data into a empty clean system)

I have never come accross a system that was total lost other than human stupidity

Are their programmers for Access - Yes loads if none in your area most VB guys can turn their hands to access and there are more of them than you can throw a stick at - if you are near a major town - then you will probably find an Access developer near by

tiem to impelment - I could write the system we use here in my office in 1 week to get a working version going and a couple more weeks to iron out the wrinkles and the possible another couple of months to get system to do 85% of whats asked for (no system will do 100% of what you ask of it)

my old system over 7 years did 95% of what we asked of it - easy on the eye , easy to use , easy to update , easy all round

 

[jonamua1971]

thanks a lot for your comprehensive reponse. i appreciate.

 

[EdFred]

I'm storing 10 years worth of data in our database.

33000+ invoices
50000+ invoice items
800+ customers
1300+ ship to addresses.

I keep waiting for a "Sorry, you can put no more records in this table error" but considering the maximum records per table seems to be 2GB, I have a ways to go.

For more info:

http://www.databasezone.com/techdocs/acclimit.html

 

[jonamua1971]

thank you very much for your response.

 

[Dennisk]

It is possible to get roung the 2gb limit by placing each table in its own .mdb file and linking however you will not be able to enforce referential integrity with linked tables, only with code. - a move to SQL would be a better option.

 

[namliam]

33000+ invoices

I have tables with millions of records, it isnt fast but works as long as you dont reach the 2gb limit (Hint: Compact!)