maximum number of records with MS Access

[usfpjc]

I am designing a simple Access Data Base.

The number of records will be about 4500.

Is this feasible with Access? or do I have to consider a more "robust" data base.

 

[SA812]

It should work. I believe the limit is on the file size the database cannot be larger than 2Gigs "freezes up", and a query cannot return more than 150 rows.

SA

 

[kallak]

In Access 97, you can go to HELP>>CONTENTS AND INDEX>>INDEX and search for "specifications". It will tell you everything you ever need to know about Access's technical specifications. The same info is likely available in Access 2000/2002, but I don't have them readily available on this computer--give it a try to see what you come up with.

To specifically answer your question: 4500 rows of data is no problem at all for Access.

The user who earlier posted that an Access query can return only 150 rows is mistaken: I regularly deal with hundreds of thousands of rows of data in both queries and tables. Each week, I download 450,000 rows from our system and process over 250,000 active ones so that they can be queried, etc. It's a piece of cake for Access.

Access 97 database containers (.mdb files) max out at a gig. However, by attaching tables stored in other containers, the amount of data you can store is limited only by available harddrive space. I believe that more recent versions of Access have a 2 gig limit on .mdb files, but by attaching to tables within other containers as I just mentioned, you can overcome the limit here, too.

In short, I don't know of a MORE "robust" PC-based database than Access, though I'm sure there are some that are equally as robust.

I hope this helps!!!

KL

 

[SA812]

Oops i didn't mean rows down but fields accros.