Hi,
I have an access database that is currently 17,000 kb and hosted on a basic hosting package with zen internet. (£5 a month). We've been testing the application for 2 weeks, but yesterday made it live to our customers.
There are about 4 or 5 users that read and update the database and MANY users that just read from the database.
Everything was fine yesterday, but today the entire system crashed and no ASP pages would run at all , they would just hang. After contacting the hosting company they said that JET was running too slow and the size of our database was too big and to recode it in SQL.
So, what would be the best way forward, is it really recoding it all in SQL? Or could changing the hosting fix the problems? Is Access really suitable?
I have an access database that is currently 17,000 kb and hosted on a basic hosting package with zen internet. (£5 a month). We've been testing the application for 2 weeks, but yesterday made it live to our customers.
There are about 4 or 5 users that read and update the database and MANY users that just read from the database.
Everything was fine yesterday, but today the entire system crashed and no ASP pages would run at all , they would just hang. After contacting the hosting company they said that JET was running too slow and the size of our database was too big and to recode it in SQL.
So, what would be the best way forward, is it really recoding it all in SQL? Or could changing the hosting fix the problems? Is Access really suitable?
