Outgrowing Microsoft Access, what next?
Posted on 2008-11-03
We have a microsoft access database which everyone in our company uses (70 or so users). Basically what's happening is that people are inputting data into this thing at a rate which is cause the size to double basically every month (the size is now 16 megs). This of course isn't sustainable since we're already experiencing slowdowns and sluggish behavior. We were wondering if hosting the database on a dedicated server would expedite things, or is that just putting a band-aid on things, or will that have little effect? I don't know much about SQL server, but is that the solution to our problem or is that overkill? Please let me know, looking for general insights on solving this issue. Thanks.