Arsip: backup database ACCESS dari Delphi

 
user image
more 18 years ago

ganang

kpd Sensei-Sensei Delphi yang +Ca...eemmm aq mo nanya caranya backup database access dari delphi gmn ya? tapi bukan backup manual langsung dari access lho mas, tolong ya ...makacheeeee
user image
more 18 years ago

delphi_warrior

untuk backup nya biasanya aku cuman pake perintah copyfileto ....utk copy file mdb ke tempat lain dgn nama lain juga.... kalo utk compact datanya...aku dapet dari .......kalo gak salah delphi.about.com.... seperti ini procedurenya uses ..., JRO_TLB; function TFUtama.DatabaseCompact (const sdbName: WideString) : boolean; var JE : TJetEngine; //Jet Engine sdbTemp : WideString; //TEMP database sdbTempConn : WideString; //Connection string const SProvider = 'Provider=Microsoft.Jet.OLEDB.4.0; Data Source='; begin Result:=False; sdbTemp := ExtractFileDir(sdbName) + 'TEMP' + ExtractFileName(sdbName); sdbTempConn := SProvider + sdbtemp; if FileExists(sdbTemp) then DeleteFile(sdbTemp); JE:= TJetEngine.Create(Application); try try JE.CompactDatabase(SProvider + sdbName, sdbTempConn); DeleteFile(sdbName); RenameFile(sdbTemp, sdbName); except on E:Exception do ShowMessage(E.Message); end; finally JE.FreeOnRelease; Databasecompact:=True; end; end; jgn lupa tambahkan jro_tlb utk usesnya... jro tlb bisa didapat dari import library yg ada di c:\program files\common files\system\ado\msjro.dll good luck yech............
user image
more 18 years ago

imunk

backup seperti apa neh, kalo cuma file .MDB nya yg mau di backup gunakan aja fungsi Copy File. Kayaknya di help Delphi dah ada tuh. moga membantu.
user image
more 18 years ago

ganang

iyaa mas itu maksudnya, tapi kalo seumpamanya suatu waktu file database yang udah dibackup mau digunakan lagi apa bisa langsung diakses ya Mas?makasih banyak ya mas delphi_warior n mas imunk jawaban sensei-sensi sekalian sangat membantu
more ...
  • Pages:
  • 1
Share to

AI Forward

🚀 We're thrilled to partner with Alibaba Cloud for "AI Forward - Alibaba Cloud Global Developer Summit 2025" in Jakarta! Join us and explore the future of AI. Register now: https://int.alibabacloud.com/m/1000400772/
#AlibabaCloud #DeveloperSummit #Jakarta #AIFORWARD

Random Topic

Local Business Directory, Search Engine Submission & SEO Tools FreeWebSubmission.com SonicRun.com