compacting a secure DB

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I have a secured database and everything works well
except that I have done a lot of work in it and it needs
to be compacted. It won't let me. Do I need to go
through the anguish of desecuring it then resecuring it
after it is compacted?

Thanks for the help.
 
Please expand on 'it won't let me'. Do you get an error message? Secure
mdb files compact just fine.
 
Joan, When I try to compact the secured database it give
me the error "You do not have the necessary permissions
to use the 'Y:\ACIDX.mdb' object. Have your system
administrator or the person who created this object
establish the appropriate permissions for you.

When I secured the database I used the security wizard
and chose for it to create a shortcut to be used to open
the database. It seems to me that I have to somehow join
the secured workgroup but I don't know how to do that
without opening the database and thus I cannot compact an
open database.

I appreciate your help.
 
Hi Steve, a couple of options.

You can open the database via the shortcut and then use Tools, Database
Utilities, Compact Database - that will compact it.

You can use a second shortcut - exactly the same as the first but add
/compact to the end of it.

You could set it to compact on close - Tools, Options, General Tab.
 
I feel like an idiot. Don't know where I got the
impression that you couldn't compact an open database but
I knew it anyway.
Thank you so much for being so generous with your time.
 
Back
Top