Hi Guys

First, i should explain i am new to VB programming although i have been building Access97 apps. for about two years now.

I have a module in an otherwise empty database that compacts and backs up another database everynight which is the one all the guys in my office log into each day.

I'd like to build it in VB, and i'm doing ok in terms of the databse name, location etc, but here is my problem:

Would i have to open some instance of Access to use DBEngine.CompactDatabase, or will it run from within VB as it is?

Sorry if this is a basic question, but we all have to start somewhere.....

I only ask as i have to do a similar thing when creating Word docs. for mail merge from within Access.

Cheers

Peter Gidden