Compacting an Access Database

Discussion in 'Databases' started by erniethomason, Jan 21, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. Is there a way to compact an Access database when running a vb.net page from discountasp? I've seen examples that use such code as

    Dim db As New DAO.DBEngine
    Dim jro As New JRO.JetEngine

    but they require COM references (maybe with a wrapper?), and I assume these are not available to me. If they are, I don't know how to add a reference for running under discountasp.net servers.

    Thanks for any input,
    Ernie
     
  2. Bruce

    Bruce DiscountASP.NET Staff

    not that i know of.
     
  3. Thanks Bruce.

    Um, I should have been more general with my question. If I want to compact an Access database on your server, do I have any means available to do this without having to copy to my local computer, compacting there, and re-uploading to your server?

    Ernie
     
  4. Ok, please disregard this thread now. I have found an alternative approach... I can just copy the records into a new/blank database and this has a similar effect (gets rid of the bloat). Thanks.
     
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page