database bloat

G

Guest

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?
 
A

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.)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Generate a new backend 2
Best way to handle customer upgrades to backend database. 10
How do I close a database 1
Database Bloat Issues 8
Deleting a table in the backend using VBA 7
Indexes with DAO 4
fe and be problems with deletion and relationships 7
Bloating 2

Top