I have a database in MS Access. I splitted the database into front-end and back-end. In the back-end, all my records have attachments (PDF) which made the database reached its limited capacity (2GB) and now, i can no longer add record. My database is still growing and who knows how much the database size would grow in the coming months. I have made research about increasing the capacity of Access but it is not possible.
My questions are:
1. Is there any database which can handle large amount of records without limitations?
2. What is the easiest and best engine to migrate my database? If the best option is MySQL, I tried but I dont know how to start.
Please help. Would appreciate it very much.
