database bloat

[Eric]

I'm getting tremendous bloat of my backend when I delete all records from
tables on the backend. My VBA is in DAO 3.6 I'm closing all my recordsets
explicitly. I'm thinking one way to eliminate is to delete the tables on the
backend and recreate them, however I cannot delete the tables even after
deleting the frontend link. Somehow the backend thinks the tables are still
being used. Any Ideas?

 

[Allen Browne]

Is there an LDB file with the same name as your back end MDB in the same
folder?

If so, delete that file. If you can't delete it, someone is still logged in.
If you are sure noone is using the database, and still can't delete it,
reboot the computer the back end is on, and then delete the little LDB file.

Once that's deleted, compact the back end database (Tools menu.)