Compact a secured db

[Connie]

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

 

[Joan Wild]

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.

 

[Connie]

Thank you Joan that worked great!!

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.