- Thola izimbangela ezivamile zenkohlakalo yokufinyelela, njengamaphutha efayela hardware kanye namagciwane.
- Zitholele izindlela zokulungisa isizindalwazi esilimele ngamathuluzi angaphakathi nangaphandle.
- Yamukela izindlela ezinhle zokuvikela ukugwema izinkinga zenkohlakalo esikhathini esizayo.
- Funda amasu athuthukile, njengokungenisa izinto noma ukusebenzisa i-Jet Compact Utility.
Lapho usebenza nama-database Microsoft Finyelela, enye yezinkinga ezikhungathekisa kakhulu esingahlangabezana nazo i inkohlakalo yefayela. Lokhu kungabangelwa ukuvalwa okungalindelekile, amaphutha wehadiwe, ukungqubuzana kwesofthiwe noma ngisho igciwane. Ngenhlanhla, zikhona ezahlukene izindlela ukuxazulula lezi zinhlobo zezinkinga futhi ugweme ukulahlekelwa kolwazi olubalulekile. Kulesi sihloko, sizohlola izinyathelo ezidingekayo ukuze sihlonze izimbangela bese siqhubeka nokuthola noma ukulungisa imininingwane egciniwe eyonakele ekufinyeleleni.
Siyabonga amathuluzi angaphakathi Ukufinyelela, izinhlelo third-party kanye namasu manual, kungenzeka ukuba alulame ingxenye enkulu idatha eyonakele ngisho nokuvimbela izinkinga zenkohlakalo zesikhathi esizayo. Sizokwenza imininingwane engcono kakhulu amasu ukusingatha lezi zimo, kusukela ezinketho ezilula kakhulu kuye kwezithuthuke kakhulu, siqinisekisa ukuthi sizimboza zonke.
Kungani izingosi zolwazi zokufinyelela zonakala?
Qonda izimbangela Ukuvimbela inkohlakalo kubalulekile ukuze kuxazululwe noma iyiphi inkinga eyenzeka ngesizindalwazi. Lapha siqoqa izizathu ezivamile:
- Amaphutha ezingxenyekazi zekhompuyutha: Ukuhluleka kwe-hard drive noma izinkinga zenethiwekhi zingonakalisa ifayela elifinyelelekayo.
- Iziphazamiso ezingalindelekile: Ukuvalwa kungazelelwe ngenkathi kwenziwa umsebenzi wokubhala kungamaka ifayela njengelikhohlakele.
- Ukungqubuzana kwesoftware: Uma usebenzisa amathuluzi okungewona awomdabu ukuvula noma ukukhohlisa amafayela okufinyelela, ukungahambisani okubulalayo kungavela.
- Amagciwane kanye I-malware: Lokhu kuhlaselwa kwekhompyutha kumele a usongo olujwayelekile ngobuqotho bedatha.
Indlela yokuhlonza nokuxazulula izinkinga zenkohlakalo
1. Umazisi wokuqala
Isinyathelo sokuqala bona amaphutha okungenzeka eziqinisekisa ukuthi isizindalwazi sonakele. Ezinye izinkomba zingase zibe imilayezo yamaphutha njengokuthi "Isizindalwazi sidinga ukulungiswa" noma izinkinga zokuvula ifayela.
2. Sebenzisa Ithuluzi Lokugcinwa Kwemininingwane Ehlanganisiwe Nokulungisa
Ukufinyelela kuhlanganisa a umsebenzi owakhelwe ngaphakathi elungisa izinkinga ezijwayelekile kumafayela e-MDB naku-ACCDB:
- Vula u-Finyelela bese ukhetha inketho ethi “Compact and Repair Database” kuthebhu ethi “Amathuluzi Esizindalwazi”.
- Thola ifayela elimele bese ukhetha indawo entsha yefayela elilungisiwe.
Nota: Le ndlela ayiqinisekisi ukululama okuphelele, kodwa iyisiqalo esihle. ukuhamba.
3. Phinda uthole idatha kusuka kusipele
Uma unamakhophi ayisipele amafayela akho, lokhu indlela Yiyona esebenza kahle kakhulu futhi enokwethenjelwa. Vele ubuyisele inguqulo yakamuva futhi ubuyele kokujwayelekile.
4. Isusa amafayela e-.LDB
Uma Ukufinyelela kusetshenziswa, kwakha amafayela .LDB ukuze kulawuleke ukufinyelela. Uma lawa mafayela engasulwa ngokuzenzakalelayo, angase aphazamise i- ukusebenza. Qiniseka ukuthi uzisusa mathupha ngaphambi kokuzama ukulungisa isizindalwazi.
5. Ukusetshenziswa kwamathuluzi athuthukile
Kukhona amathuluzi angaphandle, njenge Ukulungisa i-Stellar ukuze Ufinyelele, enikeza izici zokulungisa ezithuthukisiwe. Lokhu akuvumeli kuphela ukubuyisela idatha, kodwa futhi nokwakha kabusha izakhiwo ezifana namathebula, imibuzo namamakhro.
Uyivimba kanjani inkohlakalo kusizindalwazi sokufinyelela
Ukuvimbela kuzohlala kungcono kunokulungisa. Landela lezi amathiphu Ukunciphisa ubungozi:
- Hlukanisa isizindalwazi: Gcina idatha efayeleni ihlukene nendawo engaphambili, abasebenzisi abangenakho ukufinyelela kuyo okuqondile.
- Yenza izipele njalo: Londoloza izinguqulo zezikhathi ukuze ugweme ukulahlekelwa okukhulu.
- Vala Ukufinyelela kahle: Gwema ukuvala shaqa kungazelelwe noma ukuvalwa ngempoqo.
- Gada izingxenyekazi zekhompuyutha: Qiniseka ukuthi usebenzisa izinto zokusebenza ezisesimweni esihle futhi ezinoxhumo oluvikelekile.
Compact kokuthi Vala Izilungiselelo
Inketho ewusizo ekufinyeleleni ukunika amandla isici esithi "Compact on Closing", ukuze kuhlanganiswe ngokuzenzakalelayo isizindalwazi lapho kuqedwa ukusetshenziswa. Lesi silungiselelo sinciphisa ubungozi boku inkohlakalo okubangelwa ukuhlukana.
Izinyathelo ezithuthukile zokuthola kabusha
1. Ngenisa izinto kusizindalwazi esisha
Uma izinyathelo eziyisisekelo zihluleka, zama ukudala isizindalwazi esisha futhi ungenise izinto (amathebula, imibuzo, njll.) kulena eyonakele.
- Dala isizindalwazi esingenalutho.
- Sebenzisa inketho ethi "Ngenisa" ukuze ungenise izinto zisuka kufayela elonakele.
2. Hlanza amakhodi e-VBA
Amamojula e-VBA kwesinye isikhathi aqukethe amaphutha okonakalisa lonke ifayela. Hlukanisa futhi uhlanganise kabusha ikhodi ukuze uxazulule izinkinga ezihlobene.
3. Sebenzisa i-Jet Compact Utility
Leli thuluzi langaphandle lingakwazi ukuphatha amacala abucayi kakhulu yenkohlakalo ekuFinyeleni. Ngemva kokuyilanda, yigijime ukuze ulungise amafayela ayinkimbinkimbi.
Ukugcina imininingwane egciniwe isesimweni esifanele kubalulekile ekugwemeni izinkinga. Kusukela ekwenzeni izipele ezivamile Kusukela ekusebenziseni amathuluzi okufinyelela angaphakathi noma isofthiwe ekhethekile, kunezinketho eziningi zokuvikela idatha yakho. Nakuba izinkinga zenkohlakalo zingakhungathekisa, lesi sihloko sikunikeza zonke izici izixazululo ezingenzeka ukubhekana nazo ngempumelelo futhi uqhubeke nokusebenza ngaphandle kweziphazamiso.
Umbhali oshisekayo ngomhlaba wamabhayithi nobuchwepheshe ngokujwayelekile. Ngiyathanda ukwabelana ngolwazi lwami ngokubhala, futhi yilokho engizokwenza kule bhulogi, ngikubonise zonke izinto ezithakazelisayo kakhulu ngamagajethi, isofthiwe, ihadiwe, izitayela zobuchwepheshe, nokuningi. Inhloso yami ukukusiza ukuthi uzulazule emhlabeni wedijithali ngendlela elula nejabulisayo.