Goverana Iyezvino:

Dzidza nzira gumi neina dzakanakisa dzekugadzirisa huwori Access database mafaera (MDB/ACCDB), kusanganisira maturusi enyanzvi, akavakirwa-mukati uye nemanyorero ekudzoreredza sarudzo.

Huwandu hunoratidza kuti chikamu che58% chemasangano anotarisana nehuwori hwepadatabase kamwechete pagore. Chimwe chinotyisa chinoratidza kuti 40% yemabhizinesi anotadza kupora kubva mukurasikirwa nedata.

Yako Database Database inogona kumira kushanda kana kuratidza huori zviratidzo pasina yambiro. Mamiriro ezvinhu aya anounza kushushikana kukuru. Nhau dzakanaka ndedzekuti mhinduro dzakawanda dziripo dzekugadzirisa huwori Access database mafaira, kugadzirisa MS Access dhatabhesi zvikanganiso, uye kudzoreredza marekodhi akadzimwa.

Nhanganyaya kune gwara rekugadzirisa sei akashatiswa Access database

Nzira dzinoverengeka dzakapupurirwa dzinogona kubatsira kugadzirisa akashatiswa Access database. Izvi zvinobva kune akavakirwa-mukati maturusi ekugadzirisa kune nyanzvi yekudzoreredza software. Ichi chidimbu chinokutungamira kuburikidza nekukurumidza kugadzirisa kune zvidiki zvidiki uye epamusoro mhinduro dzinobata dzakakomba nyaya dzehuori.

Yako database inoda kutariswa izvozvi? Ngatitarisei nzira dzinokurumidza kugadzirisa danho nedanho.

1. Kunzwisisa Access Database Corruption

Dhatabhesi huwori hunoitika kana shanduko dzisingatarisirwi dzichichinja yako Access database yepakutanga chimiro. Kunzwisisa maitiro ehuori kunova kwakakosha kusati kwaedza kugadzirisa.

1.1 Zvinowanzokonzeresa Huori muDatabhesi

Zvikonzero zvakati wandei zvinokonzeresa Access database huori:

  • Hardware kukundikana semadhiraivha asina kunaka kana zvigadziriso zvine zvikamu zvakaipa zvinogadzira huwori hwepa database.
  • Zvine chekuita neSoftware senge isiriyo faira system kudzoreredza kana zviwanikwa zvinonetsa kukuvadza mafaira edatabase.
  • Zvinhu zvevanhu zvinosanganisira kubviswa kwedhatabhesi zvisina kufanira uye kuwanikwa kwevashandisi vakawanda zvinotungamira kuhuori nguva dzose.
  • Kudzimwa kweSystem nekuda kwekudzimwa kwemagetsi kana kubondera uku dhatabhesi richiramba rakavhurika zvinokonzera kukuvara kwakanyanya. Iyo dhatabhesi inogona kuguma mune isingaenderane mamiriro uye yakashatiswa.
  • Kuvhiringidzwa kwetiweki yekubatanidza paunenge uchiwana dhatabhesi kure.
  • Saizi yedatabase yakakurisa.

1.2 Mazano Anobatsira Kudzivirira Kupinda muDatabhesi Huori

Mune chimwe chinyorwa, takatopa mazano akawanda anobatsira ekudzivirira Access database huori, izvo zvinoderedza huwori ne95%. Nekudaro, isu tichiri kuda nzira dzinoshanda dzekubata nyaya dzasara.

1.3 Mharidzo Mharidzo kana Dhatabhesi Yashatiswa

Paunoyedza kuvhura dhatabhesi uye woona anotevera mhosho meseji, ipapo dhatabhesi rako rinogona kunge rakaora:

  • Unrecognized Database Format 'filename.mdb' (Kanganiso 3343)
  • Iyo dhatabhesi 'filename.mdb' inoda kugadzirwa kana kuti haisi faira re database. (Kanganiso 2239) Iwe kana mumwe mushandisi ungangove wakangosiya Microsoft Office Access nepo Microsoft Office Access dhatabhesi yakavhurwa. Iwe unoda here Microsoft Office Access kuti iedze kugadzirisa dhatabhesi?
  • Iyo dhatabhesi 'filename.mdb' haigone kugadziriswa kana haisi yeMicrosoft Office Access database faira.
  • Iyo Microsoft Jet database injini haigone kuvhura iyo faira 'filename.mdb'. Yakatovhurwa chete nemumwe mushandisi, kana iwe unoda mvumo yekuona data rayo.
  • Iyo Microsoft Jet database injini haina kuwana chinhu 'xxxx'. Ita shuwa kuti chinhu chiripo uye kuti unoperetera zita racho uye zita renzira nemazvo. (Kukanganisa 3011)
  • Zvinyorwa hazvigone kuverengwa; hapana mvumo yekuverenga pa 'xxxx' (Kukanganisa 3112)
  • Haikwanise kuvhura dhatabhesi 'filename.mdb'. Inogona kunge isiri dhatabhesi iyo application yako inocherekedza, kana faira rinogona kunge rine huori. (Kukanganisa 3049)
  • Iwe hauna mvumo inodiwa yekushandisa iyo 'filename.mdb' chinhu. (Kukanganisa 3033)
  • Rudzi rwe data renzvimbo isiriyo (Kanganiso 3259)
  • Kukanganisa kusingatarisirwi 35012
  • Microsoft Access yakaona kuti dhatabhesi iri mune isingawirirane, uye ichaedza kudzoreredza dhatabhesi. Munguva iyi, kopi yekuchengetedza yedatabase ichaitwa uye zvese zvakadzoserwa zvinhu zvichaiswa mudhatabhesi nyowani. Kupinda kunozovhura dhatabhesi nyowani. Mazita ezvinhu zvisina kubudirira kudzoserwa achaiswa mu “Kudzoreredza Zvikanganiso” tafura. (Kukanganisa 9505)
  • Iyo dhatabhesi 'xxx.mdb' haigone kugadziriswa kana kuti haisi Microsoft Access database faira.
  • 'Id' haisi index iri patafura iyi. (Kukanganisa 3800)
  • 'AOIndex' haisi index iri patafura iyi. (Kukanganisa 3800)
  • Kwete bookmark rinoshanda. (Kukanganisa 3159)
  • Reserved kukanganisa (-####); hapana meseji yekukanganisa uku. (Kukanganisa 2626/3000)
  • Iri faira rinogona kunge risina kuchengetedzeka kana riine kodhi yakaitirwa kukanganisa komputa yako.
  • Faira haina kuwanikwa
  • Iyo dhatabhesi haigone kuvhurwa nekuti chirongwa cheVBA chirimo hachigone kuverengwa. Iyo dhatabhesi inogona kuvhurwa chete kana chirongwa cheVBA chikatanga kubviswa. Kudzima chirongwa cheVBA kunobvisa kodhi yese kubva kumamodule, mafomu uye mishumo. Iwe unofanirwa kutsigira dhatabhesi yako usati waedza kuvhura dhatabhesi uye kudzima VBA chirongwa. (Kukanganisa 29081)
  • Iyo Visual Basic yeApplications purojekiti iri mudhatabhesi ine huori.
  • Microsoft Access yakaona huwori mufaira iri. Kuedza kugadzirisa huwori, tanga wagadzira kopi yekuchengetedza yefaira. Dzvanya iyo Faira tebhu, nongedzera kuManeja uye wobva wadzvanya Compact uye Gadzirisa Dhatabhesi. Kana uri kuyedza kugadzirisa huwori uhwu, unofanirwa kudzoreredza faira iri kana kuridzoreredza kubva kune yakamboita backup. (Kukanganisa 29072)
  • Shanduko dzawakumbira patafura hadzina kubudirira nekuti dzaizogadzira duplicate values ​​muindex, primary key, kana relationship. (Kukanganisa 3022)

1.4 Zvimwe Zviratidzo zveDatabhesi Yakaora

Izvi zvinotevera zviratidzo zvinowanzonongedzerawo kuhuwori hwedatabase:

  • Sisitimu inoparara kana uchiedza kuvhura dhatabhesi
  • Random password inokurudzira kana pasina password iripo
  • Zviziviso zvendima zvisipo
  • Visual Basic for Applications mameseji ehuori

1.5 Mhedzisiro paBusiness Operations

Database yehuwori mhedzisiro yebhizinesi inoratidza zvakanyanya. Zvidzidzo zvenguva pfupi yapfuura zvinoratidza nyaya dzedata dzinokonzera avhareji yekudzikira kwemazuva makumi maviri izvo zvinokanganisa zvakanyanya mashandiro akajairika. Kurasikirwa nedata kunokonzeresa aya matambudziko ekudonha:

Murume anopenga pakurasikirwa nedata mudhatabhesi rake.

 

  1. Kukanganisa Kwemari
    • Makambani eUS anotarisana neavhareji yekutyora data cost$8.60 mamiriyoni
    • Nguva dzekupora dzinosvika kumwedzi mipfumbamwe
    • Kuvaraidza kwedata uye kudzoreredza kunopedza zviwanikwa
  2. Kuvhiringidza Kwekushanda
    • Masisitimu akakosha anomira kushanda
    • Nguva yekugadzira yakatarisana nekunonoka
    • Kuvimbika kwemutengi uye kuvimbika kunotambura

Kuparara kweHard drive kana kutadza kwehurongwa kunokonzera 67% yezviitiko zvekurasikirwa nedata. Ichi chokwadi chinosimbisa kukosha kwemasisitimu akasimba ekuchengetedza uye maitiro ekugadzirisa dhatabhesi.

2. Free Built-in Access Repair Tools

Microsoft Access ine akati wandei emahara akavakirwa-mukati maturusi anobatsira kugadzirisa huwori Access database. Idzi mhinduro dzemuno dzinogona kugadzirisa zvakajairika dhatabhesi nyaya pasina chechitatu-bato software.

2.1 Compact uye Gadzirisa Database Tool

Iyo yakavakirwa-mukati Compact & Repair chishandiso chikamu chakakosha chekuchengetedza dhatabhesi chinogona kudzivirira nyaya dzakawanda. Ichi chishandiso chinoita zvinhu zviviri - chinoita kuti mafaera ako e database ashande zvirinani uye anogadzirisa madiki ehuori matambudziko.

Heino nzira yekushandisa chishandiso ichi:

  1. Start Kuwanikwa
  2. Vhara ese anoshanda database kubatana
  3. Enda kune Database Tools tab
  4. Sarudza "Compact & Repair Database Tools"
  5. Mu "Database to Compact From" dialog, sarudza dhatabhesi kuti igadziriswe.
  6. Dzvanya bhatani re "Compact".

Shandisa yakavakirwa-mukati "Compact uye Repair Database" chishandiso muMS Kuwana kubatanidza uye kugadzirisa dhatabhesi.

Isu tinomhanyisa gadziriso iyi svondo rega rega, kunyanya pamadhatabhesi anoona akawanda ekugadzirisa uye kudzima. Izvi zvinoita kuti mashandiro aite zvakanaka uye anomisa data kubva pakuzvimba.

Kuti uwane rumwe ruzivo, iwe unogona zvakare kushanyira iyo official Microsoft peji External Link.

2.2 Basa reDAO DBEngine.CompactDatabase

Iyo DAO CompactDatabase basa inotipa kutonga kwakawanda pamusoro pekuchengetedza dhatabhesi pane yakavakirwa-mukati chishandiso. Iyi nzira inoita kuti tiite otomatiki maitiro ekugadzirisa.

Iri basa rinoshanda zvakanaka neakawanda dhatabhesi anoda kugara achichengetwa. Iyo inogadzira kopi nyowani, yakagadziridzwa yedatabase yako uye inochengeta yako yese data uye zvinhu zvakamira.

Pazasi pane VBA kodhi yekugadzira batch kugadzirisa ese Access dhatabhesi pasi pedhairekitori:

Sarudzo Yakajeka ' Wedzera Windows API zviziviso Private Declare PtrSafe Function SHBrowseForFolder Lib "shell32" (lpbi As BROWSEINFO) As Long Private Declare PtrSafe Function SHGetPathFromIDList Lib "shell32" (ByVal pidVal Striring As Long, Declaration As Long PtrSafe Sub CoTaskMemFree Lib "ole32" (ByVal pvoid As Long) Private Type BROWSEINFO hWndOwner As Long pidlRoot As Long pszDisplayName As String lpszTitle Se String ulFlags As Long lpfnCallback As long As Long End Type Public Sub CompactRepairDatabases() Dim fso SeChinhu Dim folda Sechinhu Dim faira Sechinhu Dim foldaPath As String Dim stats As ProcessStats' Gadzira FileSystemObject Set fso = GadziraObject("Scripting.FileSystemObject") ' Ratidza fodha dialog dialog folderPath = GetFolderPath() Kana foldaPath = "" Ipapo MsgBox"Kushanda yakanzurwa.", vbInformation Exit Sub End Kana ' Initialize stats stats.SuccessCount = 0 stats.FailureCount = 0 ' Wana forodha chinhu Set folder = fso.GetFolder(folderPath) ' Gadzirisa faira rega rega mufolder For Every file In folder.Files ' Tarisa kana iri dhatabhesi reKuwana Kana IsAccessDatabase(file.Name) Zvino Kana CompactAndRepairDB(file.Path) Zvadaro stats.SuccessCount = stats.SuccessCount + 1 Else stats.FailureCount = stats.FailureCount + 1 End Kana Yapera Kana Inotevera faira' Ratidza mhinduro MsgBox "Process finished!" rary faira nzira tempFile = Left$(dbPath, InStrRev(dbPath, ".") - 1) & "_temp" & _ Mid$(dbPath, InStrRev(dbPath, "."))' Kuedza kubatanidza uye kugadzirisa DBEngine.CompactDatabase dbPath, tempFile ' Delete yepakutanga uye rename temp kune yekutanga Kill dbPath Zita tempFile As dbPath CompactAndRepairDB = Chokwadi Kubuda Basa ErrorHandler: CompactAndRepairDB = Nhema ' Chenesa temp file kana iripo PaKukanganisa Resume Next Kana Dir(tempFile) <> "" Wobva wauraya tempFile End Function

Kuti uwane rumwe ruzivo, iwe unogona zvakare kushanyira iyo official Microsoft peji External Link.

2.3 Kubvisa VBA Kodhi yeKugadzirisa Yakashatiswa Access Database

Yakashata VBA kodhi inogona kukonzera matambudziko edhatabhesi. Iyo / decompile switch chishandiso chakakosha chekugadzirisa matambudziko muMicrosoft Access chinogona kubatsira kugadzirisa matambudziko aya. Kunyangwe ichinzi "decompile", hakusi "kuparara" nenzira yechinyakare - haishandure kodhi yakaunganidzwa kudzosera kune kodhi kodhi. Pane kudaro, inongobvisa mavhezheni ese akaunganidzwa uchichengetedza yako yekutanga VBA kodhi, ichirega Access kudzoreredza zvese kubva kutanga.

Kuti uparadze dhatabhesi, ingo vhura Access ne / decompile switch kubva kuWindows command prompt (cmd.exe):

"C:Mafaira eChirongwa (x86)Microsoft OfficerootOffice16MSACCESS.EXE" "C:UsersccwDocumentsDatabase.accdb" /decompile

Ongorora: Tsiva nzira dzeACCESS.EXE uye dhatabhesi yako zvinoenderana.

Akakosha Chengetedzo Notes:

  • Gara uchichengetedza faira rako re database usati waparara.
  • Ichi chinhu chisina kunyorwa, saka chishandise nekuchenjerera.
  • Izvi hazvishande pane zvakaunganidzwa .mde/.accde mafaira (chete .mdb/.accdb).
  • Ita shuwa yekuvhara ese mameseji eAccess usati waparara.

Mushure mekugadzirisa:

  1. Vhura database
  2. Vhura iyo VBA mupepeti
  3. Shandisa iyo Debug - Gadzira rairo kuti udzore mamodule ese
  4. Chengetedza database

Maitiro aya anobatsira kubvisa huwori mumakodhi akabatanidzwa uye anogona kugadzirisa akawanda asinganzwisisike zvikanganiso zvine chekuita neVBA mumadhatabhesi.

2.4 Shandisa JetComp Utility Kugadzirisa Yakakuvadzwa Yekuwana Database

JetComp utility chishandiso chakamira chega chevakuru Access database. Unogona kuidhawunirodha kubva pano kana official Microsoft peji External Link.

Shandisa iyo MS JetComp yekushandisa kugadzirisa yakakanganisika Access database.

Heano mabhenefiti ayo nemiganhu:

Kubatsira Kwakakosha:

  • Svetuka kuvhura dhatabhesi usati wabatana.
  • Zvirinani pakubata dhatabhesi iyo yakajairwa Compact uye Kugadzirisa utility haigone kugadzirisa.
  • Inoshanda nepassword-yakachengetedzwa dhatabhesi.
  • Inotsigira akawanda mitauro databases.

Mienzaniso:

  • Inotsigira chete *.mdb dhatabhesi rakagadzirwa neMicrosoft Jet database injini 3.x uye 4.x.

Aya akavakirwa-mukati maturusi makuru starting point yekugadzirisa database. Kana dzikasashanda, ungangoda mhinduro dzepamberi sedziya dzakambotaurwa.

3. Free Manual Database Repair Techniques

Zvishandiso zvakavakwa hazvigaro kugadzirisa huwori Access dhatabhesi, nepo maturusi ehunyanzvi anoda imwe mari. Manual matekiniki anogona kubatsira kudzoreredza data kubva kune yakakuvadzwa dhatabhesi yemahara. Nzira idzi dzinotora nguva yakawanda asi dzinowanzopa zvibereko zviri nani pasina imwe mari.

3.1 Kupinza Zvinhu kune Nyowani Database

Iyo nzira yekuunza yatibatsira kuchengetedza data kubva kune yakaora dhatabhesi kasingaverengeki. Iyi nzira inoda dhatabhesi nyowani kuti ifambise zvakarongeka zvinhu kubva kune yakakuvadzwa. Hezvino izvo zvinoshanda zvakanyanya:

  1. Gadzira dhatabhesi nyowani, isina chinhu
  2. Vhara iyo yakagadzirwa otomatiki Tafura1
  3. Enda kune "External Data" tab
  4. Dzvanya pakanzi “Customerize Ribhoni…”
  5. Dzvanya "Boka Idzva" kuti ugadzire boka idzva.
  6. Sarudza "Access (Import Access Data)" uye wobva wadzvanya "Wedzera >>" kuti uiwedzere kuboka idzva.
  7. Sarudza "Access" kubva muboka idzva.
  8. Bhurawuza kune yako yakaora database
  9. Sarudza zvinhu zvese zvaunoda kuunza kunze
  10. Dzvanya "Sarudzo" uye ita shuwa kuti "Hukama" inotariswa.
  11. Dzvanya "Zvakanaka" kupinza zvinhu kune yako nyowani dhatabhesi.

Pazasi pane nhanho-ne-nhanho vhidhiyo tutorial:



Cherechedza:

  1. Ita backup usati waedza chero maitiro ekugadzirisa.
  2. Kana kupinza kwakatadza, edzazve nekusarudza zvimwe zvezvinhu (panzvimbo pezvinhu zvese) kudzamara kupinza kwabudirira.
  3. Iyi nzira inoshanda zvakanyanya nehuori hunyoro apo zvinhu zvinoramba zviripo.

3.2 Kupora Kuburikidza Nematafura Akabatanidzwa

Zvekunze zvinongedzo zvinobatsira kudzoreredza data kana zvakananga kunze zvisingashande. Iyi nzira inobatanidza kune yakaora dhatabhesi pasina kufambisa iyo data.

Kuti ugadzire ekunze zvinongedzo, ingo tevera maitiro akafanana ne5.1, kunze kwekunge kana uchipinza dhatabhesi, unofanirwa kusarudza "Link kune iyo data sosi nekugadzira tafura yakabatana":

Gadzira matafura akabatanidzwa muMS Access.

Mushure meizvozvo, Kuwana kuchagadzira matafura akabatana mune yazvino dhatabhesi, achinongedza kune kwakabva huwori dhatabhesi:

MuMS Access, tafura yakabatana (ine museve webhuruu) inobvumira kudzoreredza manyore kubva kune huwori dhatabhesi.

Ipapo iwe unogona kuita zvinotevera kudzoreredza matafura:

  1. Vhura tafura yakabatana.
  2. Kana iyo tafura yakabatanidzwa inogona kuvhurwa, zvino gadzira tafura itsva ine chimiro chakafanana mudura idzva.
  3. Kopa zvinyorwa zvinowanikwa mubatch. Shanda nemabheji madiki ezvinyorwa (50-100 panguva) kuderedza njodzi yekurasikirwa kwedata panguva yekuendesa.
  4. Namira mutafura itsva.
  5. Edza rekodhi yega yega mushure mekutamiswa.
  6. Dzokorora nhanho 1 kusvika ku5 kune ese akabatana matafura.
  7. Vakazve hukama uye mibvunzo
  8. Zvimwe zvinhu, zvakadai semafomu, macros, nezvimwewo, zvinogona kuitwa nenzira imwe chete.

Yedu yekuyedza inoratidza aya manyorerwo matekiniki anoshanda zvakanyanya kana:

  • Iyo dhatabhesi inoramba ichiwanika, uko mamwe matafura uye zvinhu zvichiri kushanda nepo zvimwe zvichishatiswa.
  • Maturusi ekugadzirisa akavakwa-mukati haana kushanda
  • Iwe unofanirwa kudzoreredza data chaiyo
  • Kudzvanywa kwenguva haisi nyaya

Iyi mitoo yemaoko inoda kushivirira uye kunyatsoteerera. Kukurumidza kugadzirisa kunowanzokonzera matambudziko akawanda. Tora nguva yako uye chengeta makopi ekuchengetedza mukati mekugadzirisa.

4. Kushandisa DataNumen Access Repair Kugadzirisa Huori Kuwana Database

Kana ese ari pamusoro emahara nzira akatadza, unogona kufunga nezve hunyanzvi mhinduro. DataNumen Access Repair inomira seimwe yeakanakisa nyanzvi yekugadzirisa dhatabhesi maturusi ekugadzirisa huwori Access database. Ichi chishandiso chakasimba chinoshanda neshanduro dzese kubva Kupinda 95 kusvika 2021, kusanganisira Hofisi 365.

4.1 Gadzirisa faira rimwechete

Kugadzirisa imwechete Access database faira, ndapota ita zvinotevera:

  1. Vhara Microsoft Access uye mamwe maapplication anogona kugadzirisa yako source database file.
  2. Sarudza kunobva faira redatabase (.mdb, .accdb).
  3. Kana iyo faira faira iri test.mdb/test.accdb, zita refaira rekubuda richaiswa ku test_fixed.mdb/test_fixed.accdb otomatiki. Unogonawo kushandura zita refaira rekubuda nemaoko (.mdb, .accdb).
  4. Dzvanya pakanzi “Start Gadzirisa” bhatani
  5. Mushure mekugadzirisa maitiro, DataNumen Access Repair ichaburitsa dhatabhesi idzva.

shandisa DataNumen Access Repair kugadzirisa imwe yakakuvadzwa Access database file.

4.2 Gadzirisa Batch yeMafaira

Masangano anogona kuchengetedza nguva uye kushanda nesimba neiyo batch processing ficha. Madhatabhesi akawanda akashatiswa anogona kuiswa mumutsara uye kugadziriswa zvakatevedzana DataNumen, sezvinotevera:

  1. Enda kune "Batch Repair" tab.
  2. Dzvanya "Wedzera Mafaira" kuti uwedzere akawanda Access database mafaira (.mdb, .accdb) kuti agadziriswe.
  3. Dzvanya pakanzi “Start Gadzirisa” bhatani
  4. Mafaira ese ari muchirongwa achagadziriswa rimwe nerimwe

shandisa DataNumen Access Repair kugadzirisa batch yeakakuvadzwa Access database mafaira.

4.3 Dzorera Matafura Akadzimwa uye Marekodhi

Kugona kwechishandiso kudzoreredza zvakadzimwa zvinhu zvinokatyamadza. Heino maitiro ekudzoreredza:

  1. Enda kune "Options" tab
  2. Gonesa "Dzora matafura akadzimwa" uye "Dzora marekodhi akadzimwa" sepazasi:
    shandisa DataNumen Access Repair kudzima matafura kana marekodhi mumafaira eDatabase Database.
  3. Enda kune "Gadzirisa" tab uye start kugadzirisa faira rako.

4.4 Dzorera maIndex, Hukama uye Mibvunzo

DataNumen zvinobudirira kudzoreredza zvinhu zvakasiyana-siyana zve database senge:

  • Yakaoma SQL mibvunzo (Delete, Isa, Gadzirisa mirairo)
  • Tafura hukama uye indexes

Kana iwe uchida kudzoreredza zvinhu izvi, ndapota ita zvinotevera:

  1. Enda kune "Options" tab
  2. Gonesa "Dzora indexes", "Dzora hukama" uye "Dzora mibvunzo" sepazasi:
    shandisa DataNumen Access Repair kudzoreredza zvimwe zvinhu mu Access database mafaira, kusanganisira indexes, hukama uye mibvunzo.
  3. Enda kune "Gadzirisa" tab uye start kugadzirisa faira rako.

4.5 Dzorera Dhata Yekuwana kubva kuHard Drive, Disk Image kana Backup Files

Kuwana data kunogona kudzoserwa zvakananga kubva kune hard drive, disk mifananidzo kana backup mafaera kana iwe usina iyo Access database zvakare, semuenzaniso:

  • Iwe unodzima iyo Access MDB/ACCDB dhatabhesi faira zvachose.
  • Iwe unogadzirisa hard drive.
  • Hard drive kutadza.
  • Iyo virtual disk muVMWare kana Virtual PC yakaora kana kukuvadzwa.
  • Iyo backup faira pane backup midhiya yakaora kana kukuvadzwa uye haugone kudzoreredza Access MDB/ACCDB dhatabhesi faira kubva mairi.
  • Iyo dhisiki yemufananidzo faira yakaora kana kukuvadzwa uye haugone kudzoreredza yako Access faira kubva mairi.

Kana iwe uine dhisiki mufananidzo kana mafaera ekuchengetedza paruoko, saka unogona kuita zvinotevera:

  1. Dzvanya "..." bhatani kuti usarudze iyo sosi faira.
  2. Mu "Vhura Faira" dialog, sarudza "All Files (*.*)" sefa.
  3. Sarudza dhisiki mufananidzo kana backup faira seyo faira faira kuti igadziriswe.
  4. Seta zvinobuda zvakagadziriswa faira redatabase, uye ita shuwa kuti kuwedzera kwayo kuri .mdb kana .accdb.

shandisa DataNumen Access Repair kudzoreredza Access data kubva hard drive, disk mifananidzo kana backup mafaera.

Kana iwe uchida kupora kubva kune hard drive zvakananga, unofanirwa kushandisa DataNumen Disk Image kugadzira dhisiki mufananidzo faira kune hard drive:

  1. Sarudza hard drive kana dhisiki.
  2. Seta iyo yakabuda mufananidzo faira zita.
  3. Dzvanya “Start Cloning" bhatani rekugadzira dhisiki yemufananidzo faira kubva kune hard drive / dhisiki.

shandisa DataNumen Disk Image kugadzira dhisiki mufananidzo faira kubva hard drive/dhisiki, kuitira kuti DataNumen Access Repair inogona kudzoreredza iyo Access data kubva kudhisiki mufananidzo faira.

Mushure mekunge mawana dhisiki mufananidzo faira, unogona kushandisa DataNumen Access Repair kudzoreredza data kubva kwairi.

4.6 Dzorera kubva kuRansomware kana Virus

DataNumen inoshanda zvakanyanya mukurwisa ransomware kurwiswa uye kutapukirwa nehutachiona. Ingotora iyo yakavharidzirwa kana ine hutachiona Access database faira seyosiyo yakaora faira uye gadzirisa, iwe uchawana iyo data kubva kwairi.

4.7 Sample Files

Sample yakashata Access database faira Faira rakadzoserwa na DataNumen Access Repair (Iyo 'Recovered_Table2/3' tafura mufaira rakagadziriswa inoenderana ne 'Vashandi' tafura mufaira risina kukuvara)
mydb_1.mdb (Bhug 3343) mydb_1_fixed.mdb
mydb_2.mdb (Bhug 3343) mydb_2_fixed.mdb
mydb_3.mdb (Bhug 2239) mydb_3_fixed.mdb
mydb_4.mdb (Bhug 3011) mydb_4_fixed.mdb
mydb_5.mdb (Bhug 3112) mydb_5_fixed.mdb
mydb_6.mdb (Bhug 9505) mydb_6_fixed.mdb
mydb_7.mdb (Bhug 29081) mydb_7_fixed.mdb
mydb_8.accdb (Bhug 3800) mydb_8_fixed.accdb
mydb_9.accdb (Bhug 3159) mydb_9_fixed.accdb
mydb_10.mdb (Kukanganisa 2626/3000) mydb_10_fixed.mdb
mydb_11.mdb (Yambiro yekuchengetedzwa) mydb_11_fixed.mdb

5. Kushandisa DataNumen Data Recovery kudzoreredza Access Database

DataNumen Data Recovery chimwe chishandiso chikuru kana iyo Access database faira iri lost kana kubviswa.

5.1 Dzorera Lost kana Deleted Databases

Kana yako Access database iri lost kana kubviswa nekuda kwezvikonzero zvakasiyana, unogona kushandisa DataNumen Data Recovery kuti udzoke:

  1. Start DataNumen Data Recovery.
  2. Sarudza hard disk/drive kuti utarise.
  3. Dzvanya bhatani "OK".
  4. DataNumen Data Recovery ichaongorora yakasarudzwa hard disk/drive.
  5. Mushure mekuita scan, kana dhatabhesi ichidzoserwa, ichave mune rondedzero.
  6. Sarudza dhatabhesi uye tinya "Dzora" bhatani kuti uidzorere kune folda.shandisa DataNumen Data Recovery kupora lost kana kudzima Access databases kubva kune hard drive/disk.

5.2 Dzorera kubva kuDisk Image Files

Kana iwe uchitova nedhisiki yemufananidzo faira yeiyo hard disk / drive, saka unogona kudzoreredza dhatabhesi kubva pamufananidzo faira zvakananga:

  1. Start DataNumen Data Recovery.
  2. Sarudza "Scan"> "Scan Image File" kuti utarise faira remufananidzo.
  3. Matanho asara akafanana ne3.1.

shandisa DataNumen Data Recovery kupora lost kana kudzima Access databases kubva kudhisiki mufananidzo faira.

5.3 Gadzirisa Madhatabhesi Akadzorerwa

Dzimwe nguva, iyo Access dhatabhesi inodzoserwa ne DataNumen Data Recovery vachiri nehuwori. Mumamiriro ezvinhu akadaro, unogona kushandisa DataNumen Access Repair kugadzirisa zvakare dhatabhesi yakadzoserwa uye kutora data kubva kwairi.

6. Zvimwe Sarudzo dzeKugadzirisa Huori Kuwana Database

Kunze kwese nzira idzi dzakataurwa. Pachine akawanda nyanzvi Access kugadzirisa maturusi aripo. Takaunganidza nekuongorora dzakanakisa mune rondedzero.

7. Dzimwe Mhinduro dzeKuwana Database Kuvhura Matambudziko

Nepo huwori hwemafaira huri chikonzero chakajairika chekuvhura kutadza muKuwana, dzimwe nyaya dzehunyanzvi dzinogona kukonzeresa zvakafanana kana zvakafanana zviratidzo uye meseji yekukanganisa. Kuti uone kana faira yako yakaora zvechokwadi, unogona kuendesa faira kune imwe inoshanda komputa uye edza kuivhura muAccess.

Kana iyo faira ikavhurwa zvinobudirira, huori haisi iyo nyaya. Mumamiriro ezvinhu akadaro, dambudziko ringangodaro rinobva kune yako yemunharaunda system kana Access yekuisa. Edza anotevera matanho ekugadzirisa kugadzirisa kukanganisa pakombuta yako:

  • Repair Office External Link
  • Ita shuwa kuti yako Access vhezheni inoenderana nedatabase.
  • Kamura mafaira makuru edatabase.
  • Tarisa uone kana faira rauri kuedza kuvhura rabva kune munhu akavimbika. Semuenzaniso, tarisa nzvimbo yefaira, kunyanya kana dhatabhesi iri kushanda pane sevha.
  • Tarisa uone kana zvitupa zvekuchengetedza macro zviri kuenderana uye wozvivandudza kana zvisiri.
  • Dzikisa macro chengetedzo kana uri kushandisa Access runtime kumhanyisa dhatabhesi pane kuisa iyo MS Access software pamushini wako.
  • Shandisa up-to-date antivirus software kuti uone kana faira ine utachiona nehutachiona kana malware.

8. Mhedziso

Database huwori hunogona kukanganisa zvakanyanya mashandiro ebhizinesi. Tsvagiridzo yedu inoratidza akawanda ekugadzirisa mhinduro anoshanda nemazvo. Masangano anogona kusarudza kubva akavakirwa-mukati Access maturusi, manyorerwo nzira, kune nyanzvi kudzoreredza software senge DataNumen kudzoreredza dhatabhesi ravo rakakuvadzwa. Pazasi pane pfupiso:

Rondedzero yemaitiro ekugadzirisa huwori Access database

Zvidiki zvidiki zvinogona kugadziriswa neakavakirwa-mukati maturusi ekugadzirisa. Manual kudzoreredza maitiro anopa kukosha kana yakavakirwa-mukati yemahara nzira isingashande uye iwe usingade kubhadhara, kunyangwe ichitora nguva yakawanda. DataNumen Access Repair turusi inoshanda zvirinani kunyaya dzehuori dzakanyanya.

Yako dhatabhesi inoda kugara ichigadziriswa kuti kudzivirira uori. Iyo yakazara backup zano inobatsira kuchengetedza data rako. Rongedza muitiro compact uye kugadzirisa mashandiro. Monitor dhatabhesi kushanda nguva dzose. Aya matanho ekudzivirira uye nzira dzekugadzirisa dzinochengetedza data rako rakakosha uye kuderedza inogona kuderera.

Ziva kuti kukurumidza kuita uye maturusi akakodzera anoona akabudirira dhatabhesi kudzoreredza. Idzi nzira dzekugadzirisa uye dzenguva dzose backups dzinokugadzirira iwe kubata chero dambudziko rehuori hwe database riri mberi.

References:

  1. Microsoft Corporation. (nd). Inotakurika Microsoft Jet uye DAO Zvikanganiso [Access 2007 Developer Reference]. Microsoft Dzidza. https://learn.microsoft.com/en-us/previous-versions/office/developer/office-2007/bb221208(v=office.12)External Link
  2. Microsoft Corporation. (nd). Isingazivikanwe database format . (Kukanganisa 3343). Microsoft Dzidza. https://learn.microsoft.com/en-us/previous-versions/office/office-12/bb223146(v=office.12)External Link
  3. Microsoft Corporation. (nd). Iyo Microsoft Access database injini haina kukwanisa kuwana chinhu . Ita shuwa kuti chinhu chiripo uye kuti unoperetera zita racho uye zita renzira nemazvo. (Kukanganisa 3011). Microsoft Dzidza. https://learn.microsoft.com/en-us/previous-versions/office/office-12/bb223400(v=office.12)External Link
  4. Microsoft Corporation. (nd). Zvinyorwa hazvigone kuverengwa; hapana mvumo yekuverenga pa . (Kukanganisa 3112). Microsoft Dzidza. https://learn.microsoft.com/en-us/previous-versions/office/office-12/bb223633(v=office.12)External Link
  5. Yakazara Yekukanganisa Reference: Dhawunirodha yedu yakazara Access kukanganisa kodhi runyorwa (PDF) ine 3000+ kukanganisa kodhi, tsananguro, uye inotsigirwa Access shanduro.
Goverana Iyezvino: