Large Access Table Causes runtime error

[Jim M]

Have a page that calls to an Access DB via datareader into a data grid.
Works great with all tables expect one that has 25,000 entries. Is
there a limit on the number of rows in a table that can be processed?
I get "Server Error in '/' Application"

Thanks

 

[blackstaronline.net]

Just a few days ago we tested the limits of Access 2003. At least in
..net there didn't seem to be any limits on the number of rows. We found
the limit to be when the datbase reaches 2GB in size. We did a test and
was able to write and read simple data from a table that had 1.2
Billion rows in it. Between 1.2 and 1.3 billion rows was when we
reached the 2GB size limit and our app died.

What version of access are you using?


Jeremy Reid
http://hgtit.com