I have an access2000 database and was wondering if anyone knows the max # of records in a table. and would 100million records cause a problem.

Thanks

Not sure what the limit is in A2000 but 100million would cause a problem in sql server or oracle if they weren't set up properly...

never had one has big as that, but i would have thought you need to be looking at some careful data management techniques to limit and reduce set sizes wherever possible, as anything not indexed is probably going to take a long time

I have an access2000 database and was wondering if anyone knows the max # of records in a table. and would 100million records cause a problem.

Thanks

Microsoft does not appear to provide any documentation as to absolute limits, and the only consistent references to MS Access Record Count limitations that I have seen, is that it tends to slow down after 2 million or so. I think that you probably a system designed for a larger amount.

I cannot speak for all other server options, but my experience with both Oracle and SQL Server has been that although they both have the ability to handle record counts even larger than that, the default is significantly lower. You might want to check with a database admin before assuming that your application can work on another server.

NOTE: Looks like Ken and gemma beat me to the answer again. gemma makes an excellent point regarding limiting data sets where possible. good luck