Monday, February 13, 2012

Beginner seeks help

My company needs a database. My first thought was to do it in Access, because it's available! But I wanted to check that that was smart, what its limitations are, when it's better to move to bigger / more expensive software, etc.

It's probably going to have several hundred thousand records in and will grow by more than a hundred thousand every year. Is there a size limit?

Not that many fields, though - it's not that complicated a database.

Many thanks in advance for any help :beer:MS Access 2000 has a 2 gig limit.|||Does it still have the 1 gig limit on table size? Even that would suffice for this user's requirements, most likely.|||For this situation, Access should be doable, but here are a few things to consider:

1. How many users are you going to need to support?
2. How many concurrent users do you expect at any given time?

Hope this helps in your decision-making...

-Tim

P.S. - got any more beer? :D|||If you are looking for a low price database engine , MSDE may meet your needs . MSDE if a free sql server database desktop engine , you can download it from microsoft.com .Just like sql server enterprise edition , msde also provide an easy way to back up your important data , it supports full and diffenentail backup , for access db , you have to copy the whole file for each time you back it up .

--David
databk.com

No comments:

Post a Comment