Compacting MS Access Database

  • Thread starter Thread starter Chris Wilmot
  • Start date Start date
C

Chris Wilmot

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
 
¤ 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.aspx?scid=kb;en-us;306287


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top