Re: Jet3.1&VB, Jetcomp Command line

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Paul Clement (UseAdddressAtEndofMessage_at_swspectrum.com)
Date: 06/21/04

  • Next message: Sheila Martin: "Re: Jet3.1&VB, Jetcomp Command line" 
    Date: Mon, 21 Jun 2004 15:58:12 -0500

    On Mon, 21 Jun 2004 09:40:10 +0100, "Sheila Martin" <sheila@mbssoft.co.uk> wrote:

    ¤ Hi
    ¤
    ¤ Hasd anyone got a good example of running Jetcomp via a VB6 app to repair a
    ¤ password protected Access database
    ¤

    Try using JRO (Jet Replication Objects):

    HOWTO: Compact Microsoft Access Database Through ADO
    http://support.microsoft.com/default.aspx?scid=kb;en-us;230501

    Paul ~~~ pclement@ameritech.net
    Microsoft MVP (Visual Basic)

  • Next message: Sheila Martin: "Re: Jet3.1&VB, Jetcomp Command line"

    Relevant Pages

    • Re: Strange Problem Occured Using C#&Access
      ... I used Wise Installation program for ... Access database is stored in Access 2000 format. ... > another vanilla Windows Server 2003 with zero problem. ... Only until I use the Access 2000 "repair" ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: Jet3.1&VB, Jetcomp Command line
      ... > Try using JRO (Jet Replication Objects): ... > HOWTO: Compact Microsoft Access Database Through ADO ...
      (microsoft.public.vb.database.dao)
    • =?windows-1252?Q?Records_Marked_as_=93Deleted=94_in_MS_Access_Databas?= =?windows-1252?Q?e?=
      ... Access database files. ... you need to use an inbuilt repair utility known as Compact and ... repair and restore the Access database components by using advanced ...
      (microsoft.public.access.forms)
    • Re: Compact and repair an Access database using DTS
      ... > Is there a way to execute a "Compact and Repair" process ... > in DTS for an access database. ... > and repair a database as an DTS process? ...
      (microsoft.public.sqlserver.dts)
    • Corrupted Record
      ... I have an Access Database that is set up as a split ... Recently we had a record corrupt ( ... #Error on memo field and other fields has jibberish). ... tried to repair but it won't repair. ...
      (microsoft.public.access.setupconfig)