I have used a db that opens a form where you enter the full path, including
db name that you want to compact. It works fine as long as the db you are
compacting is not secured. The code is using the CompactDatabase method of
the DBEngine
object. I tried passing the full path including /wrkgrp "path to mdw" (like
you would in a shortcut) to the olddb part of the syntax but I get "Not a
valid filename". Any suggestions on how to compact via code?

BTW, this was created back in Access97 but has been converted up to XP.

TIA
Connie

"Connie" <(E-Mail Removed)> wrote in message
news:FQSFe.7$(E-Mail Removed)...
>I have used a db that opens a form where you enter the full path, including
> db name that you want to compact. It works fine as long as the db you are
> compacting is not secured.

Actually it works if you are joined to the right workgroup. So you can
start a session of Access, where you login using the correct mdw. Then open
your db/form and you should be able to compact just fine.




--
Joan Wild
Microsoft Access MVP

Thank you Joan that worked great!!

"Joan Wild" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Connie" <(E-Mail Removed)> wrote in message
> news:FQSFe.7$(E-Mail Removed)...
> >I have used a db that opens a form where you enter the full path,
including
> > db name that you want to compact. It works fine as long as the db you
are
> > compacting is not secured.
>
> Actually it works if you are joined to the right workgroup. So you can
> start a session of Access, where you login using the correct mdw. Then
open
> your db/form and you should be able to compact just fine.
>
>
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
>