A compact problem

From: Rogelio Argueta (rogelio_argueta_at_yahoo.com)
Date: 03/24/04

  • Next message: herbert schlup: "Re: ADO and Cursors with MSSQL" 
    Date: Wed, 24 Mar 2004 13:20:31 -0600

    Hi all!!

    I need help on this problem.

    When I want to compact an Access database with this code:

    source:= 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
    C:\my_database1.mdb;User ID= Admin;Database Locking mode= 0;Mode=
    ReadWrite;';
        destination:= 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=
    C:\my_database2.mdb;User ID= Admin;Database Locking mode= 0;Mode=
    ReadWrite;';
        JetEngine.CompactDatabase(source, destination);

    I get an error like: "Cannot find an installable ISAM file" or something
    like this.

    Can you help me? please..I'm using D5, ADO, JetEngine, XP and Access 97

    Thanks in advance.
    RAH

  • Next message: herbert schlup: "Re: ADO and Cursors with MSSQL"

    Relevant Pages

    • folder permission is "read" only
      ... I am trying to automate the JEtcompact utility to compact an Access database ... I think I have the right command sequence but the ... I notice the folder with the database I want to compact ...
      (microsoft.public.windowsxp.general)
    • Re: VB.NET and ACCESS on an IPAQ
      ... > Am I overlooking something obvious? ... What you're trying to do is not supported directly through the Compact ... .Net Compact Framework MVP ... > to an ACCESS database on an IPAQ. ...
      (microsoft.public.pocketpc.developer)
    • Help with Script Task an Access database
      ... I want to compact an Access Database within a script task. ... I use this connection in a Data Flow Task to transfer data from a SQL Server ...
      (microsoft.public.sqlserver.dts)
    • Re: How to Compact database using ASP page
      ... Compact Microsoft Access Database Through ADO ...
      (microsoft.public.inetserver.asp.db)
    • Re: How to Compact database using ASP page
      ... Compact Microsoft Access Database Through ADO ...
      (microsoft.public.inetserver.asp.general)