Access Database reach limited capacity - TechRepublic
Question
September 22, 2009 at 08:39 PM
assiram

Access Database reach limited capacity

by assiram . Updated 16 years, 9 months ago

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.

This discussion is locked

All Comments