Comment Re:You're problem is Access.. not NT. (Score 1) 173
Yes, definately. Access is a desktop based single user Database, even then, I wouldn't use it for more than 10,000 records. Move to MS-SQL Server would be a good option, as the administration is 10x easier, unless you have DBA experience or have a full time DBA. Admin on Unix based DBs are a bit more difficult if you do not have prior DBA experience -> the most important factor is Database Backup and Recovery. Make sure whichever Database you choose, you have a good and well tested disaster recovery plan. We have our e-commerce site using SQL Server 6.5 sp5 (not moving to SQL 7.0 yet) and have over 20,000 records. So far (almost 2 years in operation), there has never been a problem on the database end, but the main e-commerce web server server running on NT occasionally hangs (due to the unstability of NT 4) If you do have a DBA, go for Oracle 8, definately more stable (but more $$$!)