Database

[leighcloon]

I have a client that is using an MS Access database, and the database is now full. No more records can be added. I have not developed the application for them, but they have come looking to me for advice. The original developers have gone bust. What should I recommend them to do?

Thanks in advance,
Finbarr

 

[dcx693]

No more records can be added.

Are you sure? What happens when you try? You could change the backend for storing the data and keeping the front end the same.

 

[Pat Hartman]

Have they compacted the database?

I would suggest running the database splitter wizard but it might not run if the db is at its max size. The alternative is to split the db manually.
1. Create a new db and import ONLY the tables.
2. Create a second new db and import everything EXCEPT the tables.
3. In the second db, link to the tables of the first new db.

Once everything works, you can archive the old db.