Introduction

If you use Access MDBs (for example if you use the AccessDataProvider in DNN2) then your MDBs tend to grow and grow. To compact them you have to download to your local machine, compact it, and then send it back to the web site.

I got fed up doing this so wrote a module to do it "in situ" on the web site.

How to Use

Install the module just like any other DNN module.

Add the PSof.CompactMDB module to a page. I'd recommend having a special "General Admin" page for this that only administrators can access since you probably don't want normal users to compact your databases. You should then see something like (for DNN2):-

or (for DNN3):-

Now just follow the instructions and you'll see something like (for DNN2):-

or (for DNN3):-

It's as simple as that.

Note: The module will search your entire web site for all *.mdb.resources and *.mdb files and these will appear in the dropdown list.