Isiqulatho ukufihla

Funda iindlela ezili-14 ezingcono zokulungisa iifayile ze-database zoFikelelo ezonakeleyo (MDB/ACCDB), kubandakanywa nezixhobo zeengcaphephe, ezakhelwe ngaphakathi kunye neenketho zokubuyisela ngesandla.

Ubalo lubonisa ukuba i-58% yemibutho ijongene urhwaphilizo lwedatabase kanye ngonyaka. Inyaniso eyothusayo ngakumbi iveza ukuba i-40% yamashishini ayasilela ukubuya kwilahleko yedatha eyintlekele.

Ufikelelo lwakho lwedatha lunokuyeka ukusebenza okanye lubonise iimpawu zorhwaphilizo ngaphandle kwesilumkiso. Le meko ibangela unxunguphalo olukhulu. Iindaba ezimnandi zezokuba kukho izisombululo ezininzi zokulungisa iifayile zedatabase yoFikelelo ezonakeleyo, ukulungisa iimpazamo zedatha ye-MS Access, nokubuyisela iirekhodi ezicinyiweyo.

Intshayelelo kwisikhokelo sendlela yokulungisa oovimba beenkcukacha zofikelelo ezonakeleyo

Iindlela ezininzi eziqinisekisiweyo zinokunceda ukulungisa i-database yoFikelelo eyonakeleyo. Ezi zisusela kwizixhobo zokulungisa ezakhelwe ngaphakathi ukuya kwisoftware yobungcali yokubuyisela. Esi siqwenga sikhokelela kwizilungiso ezikhawulezayo kwimiba emincinci kunye nezisombululo eziphambili ezijongana namatyala orhwaphilizo aqatha.

I-database yakho ifuna ukuhoywa ngoku? Makhe sijonge iindlela ezikhawulezayo zokuyilungisa inyathelo ngenyathelo.

1. Ukuqonda uRhwaphilizo lweDatha yeDatha

Urhwaphilizo lwedatabase lwenzeka xa utshintsho olungalindelekanga luguqula ulwakhiwo lwentsusa lwesiseko sakho sesiseko sedata. Ukuqonda ubume borhwaphilizo kubaluleka kakhulu phambi kokuba kwenziwe naziphi na iinzame zokulungisa.

1.1 Izizathu eziqhelekileyo zoRhwaphilizo lweDatha

Izizathu ezininzi ziya kubangela urhwaphilizo lwesiseko sedatha:

  • Iintsilelo zehardware njengeempazamo zehard drives okanye izixhobo zokugcina ezinamacandelo amabi zidala urhwaphilizo lwedatabase.
  • Imiba enxulumene neSoftware efana nokubuyiswa kwenkqubo yefayile engachanekanga okanye ukungqubana kwemithombo yomonakalo kwiifayile zedatha.
  • Imiba yabantu equka ukuqhawulwa kwedatha engafanelekanga kunye nokufikelela ngaxeshanye kubasebenzisi abaninzi kukhokelela kurhwaphilizo rhoqo.
  • Ukuvalwa kwenkqubo ngenxa yokucima kombane okanye iingozi ngelixa idatabase ihlala ivulekile kubangela umonakalo omkhulu. I-database inokuphela kwimeko engahambelani kwaye yonakaliswe.
  • Uphazamiseko loqhagamshelwano lwenethiwekhi xa ufikelela kwisiseko sedatha ukude.
  • Ubungakanani bedatabase bukhulu kakhulu.

1.2 Iingcebiso eziluncedo zokuThintela uRhwaphilizo lweDatha yeDatha

Kwelinye inqaku, sele sinikeze iingcebiso ezininzi eziluncedo zokuthintela ukonakala kwedatha yedatha, okuya kunciphisa urhwaphilizo nge-95%. Nangona kunjalo, sisafuna iindlela ezisebenzayo zokujongana namatyala aseleyo.

1.3 Imiyalezo yemposiso xa uvimba weenkcukacha wonakele

Xa uzama ukuvula i-database kwaye ubone le miyalezo yemposiso ilandelayo, i-database yakho inokonakala:

  • IFomathi Yesiseko Sedatha esingaqatshelwanga 'igama lefayile.mdb' (Impazamo 3343)
  • I-database 'filename.mdb' ifuna ukulungiswa okanye asiyofayile yedatha. (Imposiso 2239) Wena okanye omnye umsebenzisi usenokuba uyekile ngokungalindelekanga uFikelelo lweOfisi kaMicrosoft ngelixa isiseko sedatha seMicrosoft Office Access sasivuliwe. Ngaba uyafuna uFikelelo lweOfisi kaMicrosoft ukuzama ukulungisa uvimba weenkcukacha?
  • Uvimba wedatha 'igama lefayile.mdb' alinakulungiswa okanye asiyofayile yesiseko sedatha ye-Microsoft Office Access.
  • I-Microsoft Jet database injini ayikwazi ukuvula ifayile 'filename.mdb'. Sele ivulwe ngomnye umsebenzisi kuphela, okanye ufuna imvume yokujonga idatha yayo.
  • I-Microsoft Jet database injini ayikwazanga ukufumana into 'xxxx'. Qinisekisa ukuba into ikhona kwaye upela igama layo kunye negama lendlela ngokuchanekileyo. (Impazamo 3011)
  • Iirekhodi azinakufundeka; akukho mvume yokufunda kwi-'xxxx' (Impazamo 3112)
  • Ayikwazi ukuvula idatabase 'filename.mdb'. Isenokungabi yidatabase ebonwa sisicelo sakho, okanye ifayile inokonakala. (Impazamo 3049)
  • Awunazo iimvume ezifunekayo zokusebenzisa into ethi 'filename.mdb'. (Impazamo 3033)
  • Uhlobo lwedatha yendawo engasebenziyo (Impazamo 3259)
  • Impazamo engalindelekanga 35012
  • Ufikelelo lweMicrosoft lufumanise ukuba le datha ikwimeko engangqinelaniyo, kwaye iza kuzama ukubuyisela uvimba weenkcukacha. Ngethuba lale nkqubo, ikopi yokugcina i-database iya kwenziwa kwaye zonke izinto ezifunyenweyo ziya kufakwa kwisiseko sedatha entsha. Ukufikelela kuya kuvula isiseko sedatha entsha. Amagama ezinto ezingafunyanwanga ngempumelelo aya kufakwa kwitheyibhile "yeempazamo zokuFumana kwakhona". (Impazamo 9505)
  • Uvimba weenkcukacha 'xxx.mdb' awunakulungiswa okanye asiyofayile yedatha yeMicrosoft Access.
  • 'Id' ayisosalathiso kule theyibhile. (Impazamo 3800)
  • 'AOIndex' ayisosalathiso kule theyibhile. (Impazamo 3800)
  • Ayilophawu lokuphawula elisebenzayo. (Impazamo 3159)
  • Imposiso egciniweyo (-####); akukho myalezo walemposiso. (Impazamo 2626/3000)
  • Le fayile isenokungakhuselekanga ukuba iqulethe ikhowudi ebicelwe ukwenzakalisa ikhomputha yakho.
  • Ifayile ayifumaneki
  • I-database ayinakuvulwa ngenxa yokuba iprojekthi ye-VBA equlethwe kuyo ayikwazi ukufundwa. I-database inokuvulwa kuphela ukuba iprojekthi ye-VBA iqala ukucinywa. Ukucima iprojekthi ye-VBA kususa yonke ikhowudi kwiimodyuli, iifom kunye neengxelo. Kufuneka ulondoloze i-database yakho ngaphambi kokuba uzame ukuvula i-database kwaye ucime iprojekthi ye-VBA. (Impazamo 29081)
  • Iprojekthi yeVisual Basic ye-Aplikheyishini ekwisiseko sedatha yonakele.
  • Ufikelelo lweMicrosoft lubhaqe urhwaphilizo kule fayile. Ukuzama ukulungisa urhwaphilizo, qala wenze ikopi yokugcina ifayile. Cofa iFayile ithebhu, yalatha kuLawula kwaye emva koko ucofe iCompact and Repair Database. Ukuba ngoku uzama ukulungisa olu rhwaphilizo, kufuneka uphinde wenze le fayile okanye uyibuyisele kugcino lwangaphambili. (Impazamo 29072)
  • Utshintsho olucelileyo kwitheyibhile aluphumelelanga kuba luyakwenza impinda yamaxabiso kwisalathiso, isitshixo sokuqala, okanye ubudlelwane. (Impazamo 3022)

1.4 Ezinye iiMpawu zoBugcisa obuNcitshisiweyo

Ezi zalathi zilandelayo ziqhele ukukhomba urhwaphilizo lwedatabase:

  • Inkqubo iyantlitheka xa izama ukuvula idatabase
  • Igama lokugqitha elingaqhelekanga liyakwenza xa kungekho password
  • Izaziso zommandla ongekhoyo
  • Imiyalezo yorhwaphilizo yeprojekthi eBonakalayo eSiseko kwiZicelo

1.5 Impembelelo kwiMisebenzi yoShishino

Urhwaphilizo lweziphumo zoshishino lwesiseko sedatha zibonakala ziqatha. Uphononongo lwakutsha nje lubonisa imiba yedatha ibangela umndilili wexesha lokwehla leentsuku ezingama-20 eziphazamisa kakhulu ukusebenza kwesiqhelo. Ilahleko yedatha ixhokonxa ezi ngxaki:

Indoda iphambene kwilahleko yedatha kwisiseko sakhe sedatha.

 

  1. Impembelelo kwezeMali
    • Iinkampani zase-US zijongene nokophulwa kwedatha okuphakathi costs of $8.60 yezigidi
    • Amaxesha okufumana kwakhona afikelela kwiinyanga ezilithoba
    • Ukuzonwabisa kunye nokubuyisela idatha kudla izixhobo
  2. Ukuphazamiseka kokuSebenza
    • Iinkqubo ezibalulekileyo ziyayeka ukusebenza
    • Ixesha lemveliso lijongene nokulibaziseka
    • Ukuthemba nokunyaniseka komthengi kuyachaphazeleka

Ukuphazamiseka kwe-hard drive okanye ukusilela kwenkqubo kubangela i-67% yeziganeko zokulahleka kwedatha. Le nyaniso igxininisa imfuneko yeesistim zogcino oluluqilima kunye neenkqubo ezifanelekileyo zokugcinwa kwedathabheyisi.

2. Izixhobo zokuLungisa uFikelelo olwakhelwe simahla

UFikelelo lweMicrosoft lunezixhobo ezininzi ezakhelwe ngaphakathi simahla ezinceda ukulungisa oovimba beenkcukacha zofikelelo. Ezi zisombululo zomthonyama zinokulungisa imiba yedatha eqhelekileyo ngaphandle kwesoftware yomntu wesithathu.

2.1 Isixhobo sokuChwetheza kunye nokuLungisa iDatha yeDatha

Isixhobo esakhelwe ngaphakathi seCompact & Repair yinxalenye ebalulekileyo yogcino lwedatha enokuthintela imiba emininzi. Esi sixhobo senza izinto ezimbini - senza iifayile zakho zedatha zisebenze ngcono kwaye zilungise iingxaki ezincinci zorhwaphilizo.

Nantsi indlela yokusebenzisa esi sixhobo:

  1. Start Ukufikelela
  2. Vala lonke uqhagamshelo lwedatha esebenzayo
  3. Yiya kwi-Database Tools tab
  4. Khetha u-“Compact & Repair Database Tools”
  5. Kwincoko ethi "Database to Compact From", khetha i-database ukuze ilungiswe.
  6. Cofa iqhosha elithi "Compact".

Sebenzisa i-"Compact and Repair Database" eyakhelwe-ngaphakathi kwi-MS Access ukuhlanganisa kunye nokulungisa isiseko sedatha.

Siqhuba olu lungiso rhoqo ngeveki, ngakumbi koovimba beenkcukacha ababona uhlaziyo oluninzi kunye nokususwa. Oku kugcina ukusebenza kugqibelele kwaye kumisa idatha ekubeni idumbe.

Ngolwazi oluthe kratya, ungandwendwela i iphepha leMicrosoft elisemthethweni Ikhonkco langaphandle.

2.2 Umsebenzi weDAO DBEngine.CompactDatabase

Umsebenzi weDAO CompactDatabase usinika ulawulo olungaphezulu kugcino lwedatha kunesixhobo esakhelwe ngaphakathi. Le ndlela ivumela ukuba sizenzele inkqubo yokulungisa.

Lo msebenzi usebenza kakuhle ngoovimba abaninzi abafuna ukugcinwa rhoqo. Yenza ikopi entsha, ephuculweyo yedatabase yakho kwaye igcina yonke idatha yakho kunye nezinto zilungile.

Apha ngezantsi kukho ikhowudi ye-VBA yokulungisa zonke iinkcukacha zoFikelelo phantsi koluhlu:

Ukhetho Olucacileyo ' Yongeza izibhengezo ze-Windows API yaBucala iSibhengezo sePtrSafe uMsebenzi weSHBrowseForFolder Lib "shell32" (lpbi As BROWSEINFO) NjengeSibhengezo saBucala esiDe sePtrSafe Umsebenzi weSHGetPathFromIDList Lib "iqokobhe32" (ByVal pidValring Strepning AsLong, I-PtrSafe Sub CoTaskMemFree Lib "ole32" (ByVal pvoid As Long) Uhlobo lwaBucala BROWSEINFO hWndOwner As Long pidlRoot As Long pszDisplayName As String lpszTitle As String ulFlags As long lpfnCallback As long lpfnCallback As long cessIscessInde NjengeSiphelo esiLide soHlobo lweNkcazelo yeNkcazelo yeNkcubeko yeNkcubeko () Dim fso Njengencwadi eDim yeNgcaciso NjengeNgcaciso yeFayile eDim Njengesixhobo esiDim isiqulathi seefayiliIndlela Njengomtya Dim izibalo NjengenkquboStats ' Yenza iFileSystemObject Set fso = Yenza iObject("Scripting.FileSystemObject") ' Bonisa ifolda yesikhethi sencoko yababini Indlela = GetFolderPath() Ukuba folderPath = "" Emva koko MsgBox "Ukusebenza irhoxisiwe.", vbInformation Phuma kwiSub End Ukuba ' Qalisa izibalo stats.SuccessCount = 0 stats.FailureCount = 0 ' Fumana into yencwadi eneenkcukacha Seta isiqulathi seefayili = fso.GetFolder(iNdlela yendlela) ' Yenza ifayile nganye kwisiqulathi seefayili Kwifayile nganye ekwifolda. Khangela ukuba yi-Fikelelo yedatabase Ukuba IsAccessDatabase(file.Name) Ke Ukuba CompactAndRepairDB(file.Path) Emva koko Izibalo rary indlela yefayile tempFile = Left$(dbPath, InStrRev(dbPath, ".") - 1) & "_temp" & _ Mid$(dbPath, InStrRev(dbPath, ".")) ' Zama ukuhlanganisa kunye nokulungisa iDBEngine.CompactDatabase I-dbPath, ifayile yefayile ' Cima imvelaphi kwaye unike igama kwakhona item ukuya koqobo. dbPath CompactAndRepairDB = Imposiso yokuPhuma yiNyaniso: CompactAndRepairDB = Bubuxoki ' Coca ifayile ye temp ukuba ikhona Kwimpazamo Qhuba Ngokulandelayo Ukuba Dir(tempFile) <> "" Emva koko Bulala iTempFile End Function

Ngolwazi oluthe kratya, ungandwendwela i iphepha leMicrosoft elisemthethweni Ikhonkco langaphandle.

2.3 Ukuchithwa kweKhowudi ye-VBA yokuLungisa iDatha yeDatha yoFikelelo eyonakeleyo

Ikhowudi ye-VBA embi inokubangela iingxaki zedatha. I/decompile iswitshi sisixhobo esibalulekileyo sokucombulula iingxaki kuFikelelo lweMicrosoft esinokunceda ukusombulula ezi ngxaki. Nangona ibizwa ngokuba “yi-decompile”, ayiko “ukonakala” ngokwenyani – ayiguquli ikhowudi eqokelelweyo ibuyele kwikhowudi yemvelaphi. Endaweni yoko, isusa zonke iinguqulelo ezihlanganisiweyo ngelixa ugcina ikhowudi yakho ye-VBA yasekuqaleni, ukuvumela ukuFikelela kuqokelele yonke into ukusuka ekuqaleni.

Ukwahlula isiseko sedatha, vula nje uFikelelo nge/decompile switch kwiWindows command prompt (cmd.exe):

"C:Iifayile zeNkqubo (x86)Microsoft OfficerootOffice16MSACCESS.EXE" "C:UsersccwDocumentsDatabase.accdb" /decompile

Qaphela: Faka indawo yeendlela ze-ACCESS.EXE kunye nedatha yakho ngokufanelekileyo.

Amanqaku okhuseleko aBalulekileyo:

  • Soloko ugcina ifayile yakho yogcino lwedatha phambi kokuba udityaniswe.
  • Olu luphawu olungabhalwanga, ngoko lusebenzise ngononophelo.
  • Oku akuyi kusebenza kwiifayile eziqokelelweyo .mde/.accde (kuphela .mdb/.accdb).
  • Qinisekisa ukuvala zonke iimeko zoFikelelo phambi kokuba udityaniswe.

Emva kokuqhawula:

  1. Vula isiseko sedatha
  2. Vula umhleli weVBA
  3. Sebenzisa i-Debug - Qokelela umyalelo wokuqokelela zonke iimodyuli
  4. Gcina uvimba weenkcukacha

Le nkqubo inceda ukuphelisa urhwaphilizo kwikhowudi ehlanganiswe ngokuyinxenye kwaye inokusombulula iimpazamo ezininzi ezingaqondakaliyo ezinxulumene ne-VBA kwi-Access databases.

2.4 Sebenzisa iJetComp Utility ukulungisa iDatha yoFikelelo eyonakeleyo

Usetyenziso lweJetComp sisixhobo esizimeleyo sokufikelela kulwazi oludala. Ungayikhuphela kwi Apha okanye iphepha leMicrosoft elisemthethweni Ikhonkco langaphandle.

Sebenzisa into eluncedo ye-MS JetComp ukulungisa isiseko sedatha esonakeleyo.

Nazi iinzuzo kunye nemida yayo:

Iinzuzo eziphambili:

  • Utsiba ukuvula uvimba weenkcukacha ngaphambi kokudibanisa.
  • Kungcono ekuphatheni ugcino-lwazi olusemgangathweni olusetyenziswayo lweCompact kunye noLungiso olungenako ukululungisa.
  • Isebenza ngogcino lwedatha olukhuselweyo.
  • Ixhasa ugcino-lwazi lweelwimi ezininzi.

Imida:

  • Ixhasa kuphela *.mdb oovimba beenkcukacha ezenziwe nge-Microsoft Jet database injini 3.x kunye 4.x.

Ezi zixhobo eyakhelwe-ngaphakathi a s enkulutarindawo yokulungisa uvimba weenkcukacha. Ukuba azisebenzi, unokufuna izisombululo eziphucukileyo ezifana nezo zigutyungelwe ngaphambili.

3. IiTechniques zokuLungisa iDatha yeNcwadana yasimahla

Izixhobo ezakhelwe ngaphakathi azisoloko zilungisa oovimba beenkcukacha zofikelelo ezonakeleyo, ngelixa izixhobo zobuchwephesha zifuna imali eyongezelelweyo. Ubuchule beManuwali bunokunceda ukubuyisela idatha kwisiseko sedatha eyonakeleyo simahla. Ezi ndlela zithatha ixesha elininzi kodwa zihlala zivelisa iziphumo ezingcono ngaphandle kwentlawulo eyongezelelweyo.

3.1 Ukungeniswa kweZinto kwiDatha eNtsha

Indlela yokungenisa iye yasinceda ukuba sigcine idatha kwiindawo zogcino-lwazi ezonakeleyo amaxesha amaninzi. Le ndlela idinga isiseko sedatha esitsha ukuhambisa izinto ngokucwangcisiweyo ukusuka kulowo wonakeleyo. Nantsi eyona nto isebenza kakuhle:

  1. Yenza isiseko sedatha entsha, engenanto
  2. Vala iTheyibhile eyenziwe ngokuzenzekelayo
  3. Yiya kwithebhu ethi "Idatha Yangaphandle".
  4. Cofa kwindawo ethi "Yenza iRibhoni ngokwezifiso..."
  5. Cofa "Iqela elitsha" ukwenza iqela elitsha.
  6. Khetha u-“Fikelelo (Import Access Data)” uze ucofe u-“Yongeza>>” ukuyongeza kwiqela elitsha.
  7. Khetha "uFikelelo" kwiqela elitsha.
  8. Bhrawuza kwidatabase yakho eyonakeleyo
  9. Khetha zonke izinto ofuna ukuzithatha ngaphandle
  10. Cofa "Iinketho" kwaye uqinisekise ukuba "Ubudlelwane" bukhangelwe.
  11. Cofa "Kulungile" ukungenisa izinto kwisiseko sakho sedatha entsha.

Apha ngezantsi sisifundo sevidiyo senyathelo nenyathelo:



Phawula:

  1. Yenza i-backup phambi kokuba uzame nayiphi na inkqubo yokulungisa.
  2. Ukuba ukungenisa elizweni kuyasilela, zama kwakhona ngokukhetha ezinye zezinto (endaweni yazo zonke izinto) kude kuphumelele ukungenisa elizweni.
  3. Le ndlela isebenza ngcono ngorhwaphilizo olungephi apho izinto zihlala zikhona.

3.2 Ukufumana kwakhona ngeTheyibhile eziQhagamshelweyo

Amakhonkco angaphandle anceda ukubuyisela idatha xa ukuthunyelwa ngaphandle ngokuthe ngqo kungasebenzi. Obu buchule buqhagamshela kwisiseko sedatha eyonakeleyo ngaphandle kokuhambisa idatha.

Ukwenza amakhonkco angaphandle, landela nje inkqubo efanayo ne-5.1, ngaphandle kokuba xa ungenisa i-database, kufuneka ukhethe "Ikhonkco kumthombo wedatha ngokudala itafile edibeneyo":

Yenza iitheyibhile ezidityanisiweyo kwi-MS Access.

Emva koko, uFikelelo luya kudala iitafile ezidityanisiweyo kwisiseko sedatha yangoku, esalatha kwisiseko sedatha esonakeleyo:

KuFikelelo lwe-MS, itheyibhile edityanisiweyo (enotolo oluluhlaza) ivumela ukubuyiswa ngesandla kwisiseko sedatha esonakeleyo.

Emva koko unokwenza oku kulandelayo ukubuyisela iitafile:

  1. Vula itafile edibeneyo.
  2. Ukuba itheyibhile edibeneyo ingavulwa, yenza itafile entsha kunye nesakhiwo esifanayo kwisiseko sedatha entsha.
  3. Khuphela iirekhodi ezifikelelekayo kwibhetshi. Sebenza kunye neerekhodi ezincinci (50-100 ngexesha) ukunciphisa umngcipheko wokulahleka kwedatha ngexesha lokudluliselwa.
  4. Ncamathelisa kwitafile entsha.
  5. Vavanya irekhodi nganye emva kokudluliselwa.
  6. Phinda amanyathelo 1 ukuya ku-5 kuzo zonke iitheyibhile eziqhagamshelweyo.
  7. Yakha kwakhona ubudlelwane kunye nemibuzo
  8. Ezinye izinto, ezifana neefom, ii-macros, njl., zingenziwa ngendlela efanayo.

Uvavanyo lwethu lubonisa obu buchule bezandla busebenza ngcono xa:

  • Uvimba weenkcukacha uhlala ufumaneka ngokuyinxenye, apho ezinye iitafile kunye nezinto zisasebenza ngelixa ezinye zonakalisiwe.
  • Izixhobo zokulungisa ezakhelwe ngaphakathi azisebenzi
  • Kufuneka ubuyise idatha ethile
  • Uxinzelelo lwexesha aluyongxaki

Ezi ndlela zezandla zifuna umonde nengqalelo enyamekileyo. Ukungxama ukulungisa kudla ngokudala iingxaki ezingakumbi. Thatha ixesha lakho kwaye ugcine iikopi zokugcina kuyo yonke inkqubo yokulungisa.

4. Sebenzisa DataNumen Access Repair ukulungisa iDatabase yoFikelelo ngoBuqhophololo

Ukuba zonke iindlela ezingentla zasimahla ziyasilela, unokuqwalasela isisombululo sobuchwephesha. DataNumen Access Repair ibalasele njengenye yezona zixhobo zilungileyo zokulungisa ugcino lweenkcukacha zolwazi ukulungisa oovimba bedatha abakhohlakeleyo. Esi sixhobo esomeleleyo sisebenza nazo zonke iinguqulelo ukusuka kwi-Access 95 ukuya ku-2021, kuquka i-Ofisi 365.

4.1 Lungisa iFayile enye

Ukulungisa ifayile yedatabase yoFikelelo enye, nceda wenze ngolu hlobo lulandelayo:

  1. Vala uFikelelo lweMicrosoft kunye nezinye iinkqubo ezinokuguqula ifayile yakho yesiseko sedatha.
  2. Khetha ifayile yesiseko sesiseko (.mdb, .accdb).
  3. Ukuba ifayile yemvelaphi yi-test.mdb/test.accdb, igama lefayile yesiphumo liya kumiselwa ukuba test_fixed.mdb/test_fixed.accdb ngokuzenzekelayo. Ungatshintsha kwakhona igama lefayile yemveliso ngesandla (.mdb, .accdb).
  4. Cofa indawo ethi “Start Lungisa” iqhosha
  5. Emva kwenkqubo yokulungisa, DataNumen Access Repair izakukhupha idatabase entsha.

ukusebenzisa DataNumen Access Repair ukulungisa enye eyonakeleyo yefayile yesiseko sedata.

4.2 Lungisa iBatshi yeeFayile

Imibutho inokugcina ixesha kunye nomgudu kunye ne-batch processing feature. Iidatabase ezininzi ezonakeleyo zinokubekwa emgceni kwaye zisetyenzwe ngokulandelelana DataNumen, njengoko kungezantsi:

  1. Yiya kwi "Batch Repair" ithebhu.
  2. Cofa "Yongeza iiFayile" ukongeza iifayile zedatha yokuFikelela ezininzi (.mdb, .accdb) ukuba zilungiswe.
  3. Cofa indawo ethi “Start Lungisa” iqhosha
  4. Zonke iifayile ezikuluhlu ziya kulungiswa nganye nganye

ukusebenzisa DataNumen Access Repair ukulungisa ibhetshi yeefayile zesiseko sedata ezonakeleyo.

4.3 Fumana kwakhona iTheyibhuli neeRekhodi ezicinyiweyo

Ukukwazi kwesixhobo ukubuyisela umxholo ocinyiweyo kuyancomeka. Nantsi inkqubo yokubuyisela:

  1. Yiya kwi "Options" ithebhu
  2. Yenza ukuba "Buyisa iitafile ezicinyiweyo" kunye "Buyisa iirekhodi ezicinyiweyo" njengalapha ngezantsi:
    ukusebenzisa DataNumen Access Repair ukungacimi iitheyibhile okanye iirekhodi kwiifayile zesiseko sedata.
  3. Yiya kwi "Lungisa" ithebhu kunye start ukulungisa ifayile yakho.

4.4 Fumana kwakhona izalathisi, uBudlelwane kunye nemibuzo

DataNumen ukubuyisela ngempumelelo izinto ezahlukeneyo zesiseko sedata ezinje:

  • Imibuzo entsonkothileyo yeSQL (Cima, Faka, Hlaziya imiyalelo)
  • Ubudlelwane kwitheyibhile kunye nezalathisi

Ukuba ufuna ukubuyisela ezi zinto, nceda wenze ngolu hlobo lulandelayo:

  1. Yiya kwi "Options" ithebhu
  2. Yenza "Buyisa kwakhona izalathisi", "Buyisa ubudlelwane" kunye "Buyisa imibuzo" njengoko kungezantsi:
    ukusebenzisa DataNumen Access Repair ukubuyisela ezinye izinto kwiifayile zesiseko sedata, kuquka izalathisi, ubudlelwane kunye nemibuzo.
  3. Yiya kwi "Lungisa" ithebhu kunye start ukulungisa ifayile yakho.

4.5 Ukufumana kwakhona iData yokuFikelela kwiHard Drive, kwiDiski yoMfanekiso okanye kwiiFayile ezigciniweyo

Idata yofikelelo inokubuyiselwa ngokuthe ngqo kwihard drives, imifanekiso yedisk okanye iifayile zogcino ukuba awunayo idatabase yofikelelo kwakhona, umzekelo:

  • Ucima ifayile yedatabase yoFikelelo lweMDB/ACCDB ngokusisigxina.
  • Ufomatha i-hard drive.
  • Ukusilela kwi-hard drive.
  • Idiski enenyani kwi-VMWare okanye kwiPC ebonakalayo yonakele okanye yonakele.
  • Ifayile yogcino kwimidiya egcinayo yonakele okanye yonakele kwaye awukwazi ukubuyisela ifayile yedatabase yoFikelelo lweMDB/ACCDB kuyo.
  • Ifayile yomfanekiso wedisk yonakele okanye yonakele kwaye awukwazi ukubuyisela ifayile yakho yoFikelelo kuyo.

Ukuba unomfanekiso wedisk okanye iifayile ezigcinwe ngesandla, ngoko unokwenza ngolu hlobo lulandelayo:

  1. Cofa "..." iqhosha ukukhetha ifayile yemvelaphi.
  2. Kwincoko ethi "Vula iFayile", khetha "Zonke iiFayile (*.*)" njengecebo lokucoca.
  3. Khetha umfanekiso wedisk okanye ifayile elilalela njengefayile yemvelaphi eza kulungiswa.
  4. Cwangcisa ifayile yedatha esisigxina yesiphumo, kwaye uqinisekise ukuba ulwandiso lwayo yi-.mdb okanye .accdb.

ukusebenzisa DataNumen Access Repair ukubuyisela ufikelelo kwidata kwihard drives, imifanekiso yedisk okanye iifayile zogcino.

Ukuba ufuna ukubuyisela kwi-hard drive ngqo, kufuneka usebenzise DataNumen Disk Image ukwenza ifayile yomfanekiso wedisk yehard drive:

  1. Khetha i-hard drive okanye idiski.
  2. Cwangcisa igama lefayile yomfanekiso wemveliso.
  3. Cofa u-“Start Cloning” iqhosha ukwenza ifayile yomfanekiso wedisk kwi-hard drive/disk.

ukusebenzisa DataNumen Disk Image ukwenza ifayile yomfanekiso wedisk kwihard drive/disk, ukuze DataNumen Access Repair inokubuyisela idata yoFikelelo kwifayile yomfanekiso wedisk.

Emva kokuba ufumane ifayile yomfanekiso wedisk, ungasebenzisa DataNumen Access Repair ukubuyisela idatha kuyo.

4.6 Fumana kwakhona kwiRansomware okanye iVirus

DataNumen isebenza kakhulu ngokuchasene nohlaselo lwe-ransomware kunye nosulelo lwentsholongwane. Thatha nje ifayile yedatha efihliweyo okanye eyosulelekileyo njengomthombo wefayile okhohlakeleyo kwaye uyilungise, uya kufumana idatha kuyo.

4.7 Iifayile zeesampuli

Isampulu yefayile yesiseko sedatha ekhohlakeleyo Ifayile ifunyenwe ngu DataNumen Access Repair (Itheyibhile ethi 'Recovered_Table2/3' kwifayile emiselweyo ihambelana netheyibhile 'yabasebenzi' kwifayile engonakali)
mydb_1.mdb (Impazamo 3343) mydb_1_fixed.mdb
mydb_2.mdb (Impazamo 3343) mydb_2_fixed.mdb
mydb_3.mdb (Impazamo 2239) mydb_3_fixed.mdb
mydb_4.mdb (Impazamo 3011) mydb_4_fixed.mdb
mydb_5.mdb (Impazamo 3112) mydb_5_fixed.mdb
mydb_6.mdb (Impazamo 9505) mydb_6_fixed.mdb
mydb_7.mdb (Impazamo 29081) mydb_7_fixed.mdb
mydb_8.accdb (Impazamo 3800) mydb_8_fixed.accdb
mydb_9.accdb (Impazamo 3159) mydb_9_fixed.accdb
mydb_10.mdb (Impazamo 2626/3000) mydb_10_fixed.mdb
mydb_11.mdb (Isilumkiso sokhuseleko) mydb_11_fixed.mdb

5. Sebenzisa DataNumen Data Recovery Ukufumana kwakhona iDatabase yoFikelelo

DataNumen Data Recovery sesinye isixhobo esikhulu ukuba ifayile yesiseko sedata yi lost okanye icinyiwe.

5.1 Ukubuyisela kwakhona uLost okanye Iidatabase ezicinyiweyo

Ukuba idatabase yakho yoFikelelo ngu lost okanye icinywe ngezizathu ezahlukeneyo, ungasebenzisa DataNumen Data Recovery ukuyifumana kwakhona:

  1. Start DataNumen Data Recovery.
  2. Khetha ihard disk/drive ukuskena.
  3. Cofa iqhosha elithi "Kulungile".
  4. DataNumen Data Recovery izakuskena ihard disk/drive ekhethiweyo.
  5. Emva kwenkqubo yokuskena, ukuba i-database iyafumaneka, iya kuluhlu.
  6. Khetha i-database kwaye ucofe iqhosha elithi "Buyisa" ukuyibuyisela kwifolda.ukusebenzisa DataNumen Data Recovery ukubuyisela lost okanye icinywe uFikelelo kugcino lweenkcukacha kwi-hard drive/disk.

5.2 Buyisa kwakhona kwiiFayile zeMifanekiso yeDiski

Ukuba sele unayo ifayile yomfanekiso wedisk yehard disk/drive, ngoko ungaphinda ubuyise idatabase kwifayile yomfanekiso ngokuthe ngqo:

  1. Start DataNumen Data Recovery.
  2. Khetha "Skena"> "Scan Image File" ukuskena ifayile yomfanekiso.
  3. Amanyathelo aseleyo ayafana no-3.1.

ukusebenzisa DataNumen Data Recovery ukubuyisela lost okanye icinywe uFikelelo kugcino lweenkcukacha kwifayile yomfanekiso wedisk.

5.3 Lungisa iiDatha eziFundiweyo

Ngamanye amaxesha, i-database yoFikelelo ifunyenwe ngu DataNumen Data Recovery basenokonakala. Kwimeko enjalo, ungasebenzisa DataNumen Access Repair ukulungisa kwakhona idatabase efunyenweyo kwaye ufumane idatha kuyo.

6. Ukhetho oluninzi lokuLungisa iDatabase yoFikelelo ngoBuqhophololo

Ngaphandle kwazo zonke ezi ndlela zikhankanyiweyo. Kusekho izixhobo ezininzi zokulungisa zokuFikelela ezikhoyo. Siqokelele kwaye saphonononga ezona zibalaseleyo kuluhlu.

7. Ezinye izisombululo zokuFikelela kwiMiba yokuVula iDatabase

Ngelixa urhwaphilizo lwefayile iyimbangela eqhelekileyo yokuvula ukungaphumeleli kuFikelelo, eminye imiba yobugcisa inokuphinda iqalise iimpawu ezifanayo okanye eziphantse zifane kunye nemiyalezo yempazamo. Ukuqinisekisa ukuba ifayile yakho yonakele ngokwenene, ungadlulisela ifayile kwikhompyuter esebenzayo eyahlukileyo kwaye uzame ukuyivula kuFikelelo.

Ukuba ifayile ivula ngempumelelo, urhwaphilizo alukho umba. Kwiimeko ezinjalo, ingxaki inokuba ivela kwindlela yakho yobulali okanye ufakelo loFikelelo. Zama la manyathelo alandelayo okusombulula ingxaki ukusombulula impazamo kwikhompyuter yakho:

  • Indawo yokulungisa Ikhonkco langaphandle
  • Qinisekisa ukuba inguqulelo yakho yoFikelelo iyahambelana nesiseko sedatha.
  • Yahlula iifayile ezinkulu zedatha.
  • Khangela ukuba ingaba ifayile ozama ukuyivula ivela kumthombo othembekileyo. Ngokomzekelo, khangela indawo yefayile, ngakumbi ukuba i-database isebenza kwiseva.
  • Jonga ukuba izatifikethi zokhuseleko olukhulu zisexesheni kwaye uzihlaziye ukuba azinjalo.
  • Yehlisa ukhuseleko olukhulu ukuba usebenzisa uFikelelo lwexesha lokusebenza ukuqhuba idatabase endaweni yokuhlohla isoftware yoFikelelo lweMS kumatshini wakho.
  • Sebenzisa isoftware ye-antivirus ehlaziyiweyo ukujonga ukuba ifayile yosulelwe yintsholongwane okanye i-malware.

8. Isiphelo

Urhwaphilizo lwesiseko sedatha lunokuchaphazela kakhulu ukusebenza kweshishini. Uphando lwethu lubonisa izisombululo ezininzi zokulungisa zisebenza ngokufanelekileyo. Imibutho ingakhetha kwizixhobo zoFikelelo ezakhelwe ngaphakathi, iindlela zemanuwali, ukuya kwisoftware yokubuyisela ubungcali njenge DataNumen ukubuyisela ugcino lweenkcukacha zabo ezonakeleyo. Ngezantsi sisishwankathelo:

Isishwankathelo sendlela yokulungisa ugcino lwedatha olukhohlakeleyo

Imiba encinci inokulungiswa ngezixhobo zokulungisa ezakhelwe ngaphakathi. Ubuchule bokubuyisela ngesandla bubonelela ngexabiso xa iindlela ezakhelwe ngaphakathi zingasebenzi kwaye awufuni ukuhlawula, nangona zithatha ixesha elingakumbi. DataNumen Access Repair isixhobo isebenza ngcono kumatyala orhwaphilizo aqatha.

Uvimba wakho wedatha ufuna ukugcinwa rhoqo ukuze ukuthintela urhwaphilizo. Isicwangciso esipheleleyo sogcino lunceda ukukhusela idatha yakho. Cwangcisa imisebenzi yesiqhelo kunye nokulungiswa. Ukubeka iliso kwisiseko sedatha rhoqo. La manyathelo okuthintela kunye neendlela zokulungisa ziya kukhusela idatha yakho yexabiso kunye nokunciphisa ixesha lokuphumla elinokubakho.

Qaphela ukuba isenzo esikhawulezayo kunye nezixhobo ezifanelekileyo zinquma ukubuyiswa kwedatha eyimpumelelo. Ezi ndlela zokulungisa kunye nee-backups eziqhelekileyo ziya kukulungiselela ukuba ujongane nayo nayiphi na imingeni yorhwaphilizo lwesiseko esisengaphambili.

Iingxelo:

  1. Microsoft Corporation. (nd). Iimpazamo zeJet yeMicrosoft kunye neDAO enokubanjwa [Fikelela ngo-2007 iReferensi yoPhuhliso]. Microsoft Funda. https://learn.microsoft.com/en-us/previous-versions/office/developer/office-2007/bb221208(v=office.12)Ikhonkco langaphandle
  2. Microsoft Corporation. (nd). Ifomati yesiseko sedatha engaqondwayo . (Impazamo 3343). Microsoft Funda. https://learn.microsoft.com/en-us/previous-versions/office/office-12/bb223146(v=office.12)Ikhonkco langaphandle
  3. Microsoft Corporation. (nd). Injini yedatha yeMicrosoft Access ayikwazanga kuyifumana into . Qinisekisa ukuba into ikhona kwaye upela igama layo kunye negama lendlela ngokuchanekileyo. (Impazamo 3011). Microsoft Funda. https://learn.microsoft.com/en-us/previous-versions/office/office-12/bb223400(v=office.12)Ikhonkco langaphandle
  4. Microsoft Corporation. (nd). Iirekhodi azinakufundeka; akukho mvume yokufunda . (Impazamo 3112). Microsoft Funda. https://learn.microsoft.com/en-us/previous-versions/office/office-12/bb223633(v=office.12)Ikhonkco langaphandle
  5. Gqibezela iNdlela yempazamo yoFikelelo: Khuphela uluhlu lwethu olubanzi lwekhowudi yempazamo yokuFikelela (PDF) equlathe 3000+ iikhowudi imposiso, iinkcazelo, kunye neenguqulelo Access oluxhaswayo.