| | Reasons for Problems: | Solutions: |
| Poor Design | Many times you can get away with poor design many times when using Access for sometime extended time. But as the data grows or the needs grow, the poor design can put up a roadblock to proceed any further. | Improve design by obtaining additional expertise |
| Number of Users | Many times Access databases are initially intended for only one person. But as time goes on, others see the benefit in using the database. So maybe you are up to several users and are experiencing great problems with it now. | Move the tables to a SQL Server back end. |
| Too Much Data | As you add more and more data to Access it will eventually reach a point where it cannot the amount of data. | Move the tables to a SQL Server back end. |
| Can't make design changes | Some design changes to the database can only be made when the person who is trying to make design changes to the database has exclusive use of the database. When you have multiple concurrent users, this will be a problem. | Split the MDB into two databases: a front-end and a back-end MDB |