Could anyone tell me how to compact a MS Access Database,

I currently have an application that adds, romoves data from a MS Access
database Knowing the database will increase in size constantly dispite the
removal of records I was wanting to run a maintanance routing on initiation
of the application but can't find the routing to compact the database.

Any other sugestions of routines would be appreciated

Thanks in advance

Chris Wilmot

Thanks that did the job

Chris Wilmot


"Paul Clement" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Thu, 31 Jul 2003 11:28:55 +0100, "Chris Wilmot"
<(E-Mail Removed)> wrote:
>
> ¤ Could anyone tell me how to compact a MS Access Database,
> ¤
> ¤ I currently have an application that adds, romoves data from a MS Access
> ¤ database Knowing the database will increase in size constantly dispite
the
> ¤ removal of records I was wanting to run a maintanance routing on
initiation
> ¤ of the application but can't find the routing to compact the database.
> ¤
> ¤ Any other sugestions of routines would be appreciated
> ¤
>
> See the following MS KB article:
>
> HOW TO: Compact a Microsoft Access Database by Using Visual Basic .NET
> http://support.microsoft.com/default...b;en-us;306287
>
>
> Paul ~~~ (E-Mail Removed)
> Microsoft MVP (Visual Basic)

On Thu, 31 Jul 2003 11:28:55 +0100, "Chris Wilmot" <(E-Mail Removed)> wrote:

¤ Could anyone tell me how to compact a MS Access Database,
¤
¤ I currently have an application that adds, romoves data from a MS Access
¤ database Knowing the database will increase in size constantly dispite the
¤ removal of records I was wanting to run a maintanance routing on initiation
¤ of the application but can't find the routing to compact the database.
¤
¤ Any other sugestions of routines would be appreciated
¤

See the following MS KB article:

HOW TO: Compact a Microsoft Access Database by Using Visual Basic .NET
http://support.microsoft.com/default...b;en-us;306287


Paul ~~~ (E-Mail Removed)
Microsoft MVP (Visual Basic)