Seven Myths about MS Access Databases
1. It is a Toy – Not for Real Database Use
False. Where did you hear that – and who did you hear it from? Access gets a bad press from SQL Server Developers because it is so much easier to design a complete system with it than using, for example .NET Forms and SQL Server.
Literally tens of thousands of Companies rely on Access Databases every day. Bluebird Software on its own has written at least fifty Access Database Systems which are in daily use.
2. You can’t share the Database with others.
Not True. Yes you can!! Access is designed to be shared across a network or even over the internet. The reason some people say this is that the database they have used has not been installed correctly for multiple users. There are many instances of over one hundred people sharing the same Access Database.
3. It is not good for storing large amounts of Data
False. The question really is “What do you mean by large? Access directly supports two Gigabytes of data which is a massive amount of data for most purposes. In fact there are ways that this limit can be exceeded by simply linking to tables in other databases.
4. It crashes frequently
Not True. Older networks with poor connectivity and old PC’s with limited memory used to cause problems but not now. Crashes are now extremely rare. In the unlikely event that a data table is corrupted, it can usually be recovered without loss of data.
5. It can’t be updated easily
False. Access is one of the easiest databases to update, additional fields and tables can easily be added to take account of changing circumstances. New Forms. Queries and Reports can be rapidly added to existing databases.
6. It can’t be linked to other databases
Not True – Not only can it be linked to other databases it can also such as MySQL and SQL Server, it can also be linked to Excel Spreadsheets and SharePoint List. We have several applications where the Access Database is directly linked to a MySQL Web Server and will be happy to show you
7. It Can’t be used with Macs.
False. Access can be used natively using Parallels, Crossover or Bootcamp. The raw data in the tables can be linked via ODBC to OpenOffice.