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: http://dmxready.helpserve.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=25 Microsoft has also written an article about Access’s limitations, including a comparison chart, which you can find here: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acmsdeop.
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.
Related Questions
- So the bad guys discovered javascript could be injected into Microsoft databases via poorly written web applications. How did they make hay of that development?
- So the bad guys discovered javascript could be injected into Microsoft databases via poorly written web applications. How did they make hay of that development?
- Where can I learn more about MySQL and Microsoft Access databases?
- Where can I learn more about MySQL and Microsoft Access databases?
- Are there any limitations to using Microsoft Access databases?
- How Do You Create A New Database In Microsoft Access 2007?
