Hello to everybody I would really like ur opinion on this subject. I have this case. About 10 mde (Access Programs) with around 2GB of Access Databases A lot of Code and a lot of data...i have tables with 2 million records These programs are used from about 70 users We are talking about a LOT reads and writes. It is natural that my old Dell Server with 3 SCSI 33.6gb (raid 5) is showing its age...and so the million dollar question is..should i go to SSD Does SSD have good behavior under continous and heavy usage.Anyone having a success story. Also should i buy Enterprise SSD($1000 each) or consumer editions ($250) Dell is good but the SSDs its selling are too expensive....4 x 50GB = $4000 instead of maistream MLC 4 x 250 = $1000 (Yes i am considering raid 10)
The Jet engine has some interesting performance tweaks in it, and can provide very basic multi-user access but trying to use it across a network and/or trying to support concurrent users on it is like using a teaspoon to mix concrete. There's nothing wrong with teaspoons - its just the wrong tool for the job.
Port the data to a proper multi-user DBMS (SQL Server, MySQL, PostgreSQL, Oracle....there are lots of products available, MySQL and PostgreSQL are free) then connect the applications via ODBC (note that for bulk operations you'll not see significant performance benefits without using the SQL pass-thru).