Are there any limitations to using Microsoft Access databases?
Posted by DMXReady Admin on 17 January 2011 03:08 AM
Q. Are there any limitations to using Microsoft Access databases? |
A. Yes. Microsoft Jet (MS Access) is not intended to be used for high-traffic websites. Applications that use an Access database are usually cheaper and easier to use. But the trade-off is that its simplistic structure can be easily overloaded (only 255 people can be viewing your website at a time without crashing the database).
This is normally not a problem for small to medium-sized businesses. However, if you plan to install your DMXReady application into a high-traffic website, we suggest that you convert it for use with MySQL.
You can read more about that here:
Microsoft has also written an article about Access limitations, including a comparison chart, which you can find here: