Either Access or MS SQL databases will
suffice for most site however the selection depends on the function of the site.
We strongly recommend that MS SQL database be use for site that does e-commerce
transaction (such as payments, orders etc.), for sites that
collects confidential info such as credit card and other private info.
For sites that has easily replaced and non
confidential data then Access database be used.
Access database is stored
along with the site while MS SQL database is stored on an external server that
is only accessiable via the site code. This security enhancement along
transaction logs and database backups every 30 minutes in addition to tne many
technical advantages further makes MS SQL and ideal choice for e-commerce
sites.