My site is based in ASP with several server side MS Access databases. The site has been getting a lot of traffic lately and the server has been going down. I had a couple of databases that were 9 or 10 MB, so I broke them into separate ones, hoping that would help. It did somewhat, but the problem doesn't seem to go away. I also checked my code to make sure that I am not opening new database connections without closing them.
Any idea what this could be? A friend of mine seems to think that I just need to switch to MS SQL Server. Is that likely the problem? Do I need to get on a bigger hosting service maybe?
