umairraja52 — 2010-03-07T04:34:27-05:00 — #1
I am using database Microsoft Access with my website, i have few technical question related to this.
Can Access handle 60,000 Records Per Month.
Can Access give permissions to almost 20 people to view different records at a time.
Can Access provide report services with web pages.
I have these few question's related to Microsoft Access.
Waiting for Experts answers.
r937 — 2010-03-07T05:51:40-05:00 — #2
the answers are yes, yes, and yes, respectively
verschha — 2010-03-08T05:43:22-05:00 — #3
davemaxwell — 2010-03-08T07:17:16-05:00 — #4
Agreed, provided the coding/sql statements you use are handled correctly. Far too often, Access is blamed for not supporting decent workloads, when it is often the fault of the code accessing the database for doing things like not opening connections late/closing them early or keeping rows locked through suboptimal/poorly written queries.
Access is probably one of the least forgiving in terms of adjusting for poorly written code/queries. It does GREAT with what you give it, but if what you give it garbage, then your results/performance are going to be the same.
wwb_99 — 2010-03-08T10:18:54-05:00 — #5
Technical answers are yes. Real world answers are "you probably shouldn't do that."
I'd also argue for something of that scale, you are going to want some features which access can't handle--like triggers, transactions and online backups.