if your database is too stupid to be stable-- then move to something
that is.
SQL Server works perfect for me-- I never have to compact and repair.
I believe that 'Auto-Shrink' is enabled by default on smaller editions
of SQL Server
-Aaron
On Jul 2, 5:15=A0am, teddysn...@[EMAIL PROTECTED]
wrote:
> My client has asked if it's possible to Compact and Repair his Front
> End database programmatically. =A0I remember doing this from a VB
> application about 10 years ago, so I wondered if it was possible in
> Access.
>
> The application is Access 2003 in 2002-2003 File Format.
>
> I've added the following function to the Front End in a global module:
>
> Public Function CandRDB()
>
> CommandBars("Menu Bar"). _
> Controls("Tools"). _
> Controls("Database utilities"). _
> Controls("Compact and Repair Database..."). _
> accDoDefaultAction
>
> End Function
>
> and created an AutoExec macro that only calls this function. =A0It
> appears to be working (something happens, there's an hourglass cursor
> for example) but then barfs with the following:
>
> "-2147467259 =A0Method 'accDoDefaultAction' of object
> '_CommandBarButton' failed"
>
> From what I've read, this can happen if the Menu Bar is not visible,
> but it is.
>
> Any thoughts? =A0I know that the database can be set to compact on exit,
> but that's not what the client has asked for.
>
> Thanks
>
> Edward
|
