File size in Access 2003

[Tony Williams]

Is there a maximum limit to the number of records that Access 2003 can
handle? I have been asked to combine 3 Excel spreadsheets each with their
limit of 65000 lines into one database and I wondered whether Access 2003 can
cope with this and what the reaction time is likely to be for queries etc.
Thanks
Tony

 

[Tony Williams]

Just seen some other post which have answered my question. Seems the file
size is the important factor, not going beyond 2gb and the number of records
is relativley immaterial. is that not so?
Thanks
Tony

 

[John Spencer]

Access has no limit on the number of records. It does have a limit of 2 gigs
on the overall size of any one database.

Access should have no problem handling the data in three spreadsheets,
although you probably would need to set the data up in a different manner than
it is in the spreadsheets.

The responsiveness will depend on the design of the data and the
implementation of indexes on various fields and what you are doing.

I have tables with over two million records and can pull out the needed 20 to
200 records for one client in less than a second.

Be prepared for a learning curve, Access is not EXCEL on steroids and EXCEL is
not Access on steroids. They are different products and each has strengths
and weaknesses. For instance, Excel is much better at what if financial
analysis. Access is much better at selecting data and reordering it.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[Tony Williams]

Thanks John
Tony

Access has no limit on the number of records. It does have a limit of 2 gigs
on the overall size of any one database.

Access should have no problem handling the data in three spreadsheets,
although you probably would need to set the data up in a different manner than
it is in the spreadsheets.

The responsiveness will depend on the design of the data and the
implementation of indexes on various fields and what you are doing.

I have tables with over two million records and can pull out the needed 20 to
200 records for one client in less than a second.

Be prepared for a learning curve, Access is not EXCEL on steroids and EXCEL is
not Access on steroids. They are different products and each has strengths
and weaknesses. For instance, Excel is much better at what if financial
analysis. Access is much better at selecting data and reordering it.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County