Which Database to choose?

Root Folder > Databases

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.