Re: compacting a secure DB

From: Joan Wild (jwild_at_nospamtyenet.com)
Date: 03/30/04 

Date: Tue, 30 Mar 2004 09:39:47 -0500

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. 

-- 
Joan Wild
Microsoft Access MVP
"Steve" <anonymous@discussions.microsoft.com> wrote in message
news:15a2e01c4165c$038f1ed0$a401280a@phx.gbl...
> 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.

Relevant Pages

  • RE: Compacting MDB help
    ... The autoexec macro opens a ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ... I'm quite certain that you can't Compact an open database from within itself ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... This will cause the database to grow so Compacting ... not split off the tables from your FrontEnd. ... The FrontEnd.mdb's main switchboard has a cbo to switch back end ... FECompact.mdb runs the few lines of code to compact the FrontEnd.mdb ...
    (microsoft.public.access.modulesdaovba)
  • RE: Compacting MDB help
    ... not practical to have staffpersons open another database in order to switch ... When the front end opens, it goes directly to the main switchboard. ... the only reason why you would need to Compact the ...
    (microsoft.public.access.modulesdaovba)
  • Re: Access crashes when opening form
    ... Allen Browne - Microsoft MVP. ... You were correct in suspecting SP3. ... I've also had a problem with "compact on close" not working (it ... database works correctly there. ...
    (microsoft.public.access.forms)
  • Re: Compacting Backend Access Databases
    ... when I ran the procedure to compact ... use of the back-end database. ... Dim strBackendPathAndName As String ...
    (microsoft.public.access.modulesdaovba)