Compacting Source Database (1 Viewer)

[neoartz237]

I have my tables database separated from my app mdb and I connected them through linking.

As we all know, everytime you use the db, it bloats, so my Backend.mdb bloated upto 300+MB but then when I tried compacting it through the compact on close from Access, and it shrunk to 15MB! Nice

So how can I compact my BackEnd.mdb from my App.mdb?

As I've heard you can use the CompactDatabase() function, but it never actually compacts the original database but merely creates a compacted version of it, hence there`s a sourcepath and a destinationpath.

So How can I compact that database only?

I've tried giving the CompactDatabase only one argument for the sourcepath, but it gives errors

Please help

 

[neoartz237]

never mind I managed to do fix it yesterday