Question on MS Access limits

[Daniel]

What is the limits of an Access database. Is there a good
source that talks about this issue. I was recently
informed that the data analysis project i've been
developing in Access may reach the 100(hundred) Mb mark
soon with 200-400 thousand rows of data. That's 100 Mb of
raw data which goes into a single Access database, under
one single table. So far (10 Mb), Access has been doing
fine. The database's purpose is to simply serve as a
lookup table on each person's desktop. It will not be on a
server with multiple users accessing it.

I was asked to look into Oracle or SQL Server as
alternatives. Is this necessary, or will Access bog down
under such data. Also, how many tables can Access handle
in a single database before significantly eroding
performance ??

 

[Kevin3NF]

Access 2000 or newer has a max file size of 2GB. Access 97 limit is 1 gb.

In this situation, Oracle and SQL Server sound like overkill. If you are
planning to store a copy of the actual data on each person's desktop, please
re-think it. Keep the data on the server in one Access db, and a second db
on the desktops with links to the tables on the server.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm