HOW MANY 14 FIELD ENTRIES CAN BE STORED IN ACCESS ?

[Guest]

I am starting a company that will store thousands of names, addresses and
general data. There will be a total of 14 fields with and average of 15
characters per field. Approx. how many entries will this system accomodate?

 

[Albert D. Kallal]

The max size of a database is 2 gigs.

However, often each character takes two characters (uni-code), but,
ms-access does comps. So, lets assume we can
store 1 gig of characters...

So,

14 fields * 15 chars = 210 chars per record

1 gig of chars = 1,000,000,000 / 210 = 4,761,904

So, we get 4.7 million records....

The above is a very rough calculation, but we are talking millions of
records....

 

[dbahooker]

what do you use characters for everything?

no numbers?

no wonder you dipshits still use MDB because you don't know JACK SHIT
about RDB design

 

[dbahooker]

if you have more than 1,000 records you should be using SQL Server.

I'd like to say that if you have ANY records you should be using SQL
Server.

I've had MAJOR stability problems with a half dozen users and 25mb in
MDB.

 

[Guest]

Thanks so much.
Best Regards