1000 records is nothing. If the only queries that will be runnign are
Select (no insert, updaes and deletes) Access can handle quite a bit. But
what really counts here is the amount of concurrent users hitting the site.
1 user searching through 1000 items is nothing, whereas 1000 users searching
1 item at the same time would kill most sites.
MS does not recommend using an Access database with IIS. There
are sporadic reports of failure. Also, handling backup and
database changes can be difficult if you are using an Access
database.
