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.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
