Originally Posted by
Ajax
*snip*
SQL Server, Oracle and the like are no faster than access in most situations, they can actually be slower in real life. From a performance perspective, where they win is they can utilise four cores of processing power, whilst access (plus Sql server express, and MySQL) only uses one. However Oracle is being used for many other things which will take up usage of those cores, so the benefit could well be reduced.
They also do server side processing - the equivalent performance of a user having the backend on their machine - or (and this is an alternative strategy for you) access located on terminal server or citrix. So you can roughly even out the performance advantage on processing. Obviously, if you are moving for improved data security, volume of data to be stored or concurrent users in excess of 255 (well perhaps a bit less) then no contest, you need to move.
*snip*