how many records can be handled 1

[davikokar]

I'm building a lexicon using access. One of the table would contain more then 20 thousand records, 7 fields with string values up to 200 charachters... are this numbers bearable in access... or will it be something unusable?

 

[traingamer]

It should be fine. Access databases can be as large as 2gig each.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Golom]

In Access terms, 20,000 records is fairly trivial. A table can be up to 1 GB with 255 fields. Text fields are limited to 255 characters.

You are looking at about 27 MB in this table assuming that every field is filled with 200 characters and less than that of they contain shorter strings.

 

[dhookom]

I recently read postings in another forum where developers tried to see how many records they could stuff into a single table. The max was about 166 million. There wouldn't be much room to do anything with these records and there was only a single yes/no field which wouldn't be of much use .

You might be approaching another limit which is about 2000 characters per record. The maximum characters in 7 fields would be only 1785 if each field had 255 characters.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]