Database size limits - MS Access

[idaho]

I'm working on a website that uses an Access database (not my choice) and my question is this...

How many records can I have in the Access databse before is becomes too large and starts being inefficient for web use? In other words, how big can it be before is becomes a pain in the butt for users?

[Leelou]

I think the size limit is pretty big - 2 or 4 GB for an Access db. But I recently had a problem with MS IIS refusing to allow a query that returned a recordset larger than 4 MB; I had to truncate the display to only the top 1000 rows. The processing speed of your server and what software it runs might affect how much of a pain the huge db is for end users.