database bloat

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eric - 10 Dec 2006 08:02 GMT

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?

Reply to this Message

Allen Browne - 10 Dec 2006 12:26 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> 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
[quoted text clipped - 5 lines]
> still
> being used. Any Ideas?

Reply to this Message