Dismiss Notice

REGISTRATION IS AFTER ADMIN ACTIVATION

DONATIONS WITH PAYPAL CLICK TO BUTTON

1 MONTH VIP - 5$; 3 MONTHS VIP - 10$; 6 MONTHS VIP - 20$; 1 YEAR VIP - 30$; 2 YEARS VIP - 50$; GOLD USER FOR LIFE VIP - 150$

DONATIONS WITH Bitcoin Address:3NRs3CK3fhXifrNYxHEZKpETDd9vNLMsMD

Dismiss Notice
The registration is approved by the Administrator. It takes about 1 day to approve your registration
Dismiss Notice
For open hidden message no need write thanks, thank etc. Enough is click to like button on right side of thread.

Access DataBase Notes

Discussion in 'Delphi Programming' started by saedi_mehdi, Dec 4, 2013.

  1. saedi_mehdi
    Offline

    saedi_mehdi DF Junior

    How to Compact and Repair an Access Database?
     
  2. darioosh2040
    Offline

    darioosh2040 Guest

    thank you
     
  3. wahyujana
    Offline

    wahyujana DF Member

    RE:

    function TForm1.CompactMDB(const DBFile, Pwd: string): Boolean;
        var
          TempDBFile:string;
          ConStr:string;
          JE:OleVariant;
        begin
          ConStr := 'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;'
                                        +'Jet OLEDB:Database Password=%s;';
          TempDBFile:=ExtractFilePath(Application.ExeName)+'Temp.mdb';
          try
            JE:=CreateOleObject('JRO.JetEngine');
            JE.CompactDatabase(Format(ConStr,[DBFile,Pwd]),
                Format(ConStr,[TempDBFile,Pwd]));
             Result:=CopyFile(PChar(TempDBFile),PChar(DBFile),False);
            DeleteFile(PChar(TempDBFile));
          except
            Result:=False;
          end;
        end;

    procedure TForm1.buttonCompactClick(Sender: TObject);
    begin
    DM.Connect.Close;
    DM.Connect.Connected := False;
    CompactMDB(ExtractFilePath(Application.ExeName)+'database.mdb','');
    ShowMessage('Compact Database Berhasil..!');
    end;
     
  4. MoneerAhmed
    Offline

    MoneerAhmed Guest

    thank you
     
  5. delphix
    Offline

    delphix DF Member

    txxxx
     
  6. Guille
    Offline

    Guille DF Member

    thanks
     
  7. sascha
    Offline

    sascha Guest

    [font='Open Sans', Arial, Tahoma, Verdana, sans-serif]thank you[/font]
     
  8. Prof_Ho2
    Offline

    Prof_Ho2 DF Member

    Good bit of info thanks
     

Share This Page

Laws
Our website, law, laws, copyright and aims to be respectful of individual rights. Our site, as defined in the law of 5651 serves as a provider of space. According to the law, contrary to the law of site management has no obligation to monitor content. Therefore, our site has adopted the principle of fit and remove. Works are subject to copyright laws and is shared in a manner that violated their legal rights, or professional associations, rights holders who, adsdelphi@gmail.com I can reach us at e-mail address. Complaints considered to be infringing on the examination of the content will be removed from our site.
Donate Help To Us and Be VIP
DONATIONS WITH PAYPAL CLICK TO BUTTON
6 MONTHS VIP - 20$; 1 YEAR VIP - 30$; 2 YEARS VIP - 50$; GOLD USER FOR LIFE VIP - 150$
Social Block