- Thola izimbangela ezivame kakhulu zamaphutha nenkohlakalo ku yolwazi Finyelela.
- Zitholele zonke izindlela ezisebenzayo zokulungisa nokuthola amafayela okufinyelela alimele.
- Sebenzisa izincomo nezindlela ezihamba phambili zokugwema izinkinga futhi uthuthukise ukusebenza kwezingosi zakho zolwazi.
Ukusebenza nama-database e- Microsoft Finyelela Kungaba okuhlangenwe nakho okulula futhi okusebenzayo… kuze kube yilapho kuvela izinkinga ezifana amaphutha efomethi o ukonakala ezinqolobaneniAkuvamile ukuthi uhlelo lokusebenza lubonise imilayezo efana "nefomethi yesizindalwazi esingaziwa," "isizindalwazi sidinga ukulungiswa," noma singafinyeleleki ngemva kokuphela kwenethiwekhi noma ukuvala shaqa okungalindelekile. Lezi zigameko zingase zikhathaze, ikakhulukazi uma singekho isipele sakamuva noma lapho abantu abambalwa besebenza efayeleni elifanayo.
Kulo mhlahlandlela ophelele siyachaza Yini ebangela lawa maphutha ekufinyeleleni, yiziphi izinhlobo zemilayezo ezingase zivele, indlela yokuzibona, yiziphi izindlela ezingcono kakhulu zokuvimbela inkohlakalo futhi, ngaphezu kwakho konke, indlela yokulungisa i-Access database Sisebenzisa kokubili izinsiza ezakhelwe ngaphakathi nezixazululo ezithuthukile, siphinde sinikeze izincomo zokugcina amafayela akho esesimweni esihle futhi uvimbele izinkinga ezizayo.
Izimbangela ezivamile zamaphutha okufometha nenkohlakalo ekufinyeleleni
Izinkinga ku-Microsoft Access zingavela ngenxa yezizathu ezihlukahlukene. Kubalulekile ukuqonda izimbangela eziyinhloko ukuze ukwazi ukuphendula ngokushesha futhi unciphise ubungozi:
- Vula amafayela anezinguqulo ezahlukene zokufinyelela: Ukuzama ukuvula isizindalwazi esidalwe kunguqulo entsha yokufinyelela enenguqulo endala kungase kuqalise iphutha elesabekayo “lefomethi yesizindalwazi esingaziwa” (iphutha 3343). Okuningi mayelana namaphutha kokuthi Ukufinyelela.
- Isistimu ephuthumayo noma Ukuvalwa kokufinyelela: Vala i-PC ngaphandle kokuvala uhlelo kuqala. noma uphoqelele ukuvala usebenzisa amathuluzi afana no-Ctrl+Alt+Del angashiya amafayela esesimweni sokungahambisani.
- Ukufinyelela kwenethiwekhi nezinkinga zemvumeEzimweni ezinabasebenzisi abaningi, izimvume zefayela ezingalungile noma izinkinga zamalungelo abasebenzisi kumaseva zingaholela ekufinyeleleni amaphutha nenkohlakalo.
- Inkohlakalo by hardware noma isofthiwe: Ukwehluleka kwe-hard drive, imikhakha emibi, amagciwane, ukucisha kukagesi, noma izinkinga nge-MS Office suite nakho kungaba nesibopho.
- Ukusetshenziswa okuhlanganisiwe nezinye izinhlelo: Ukusebenzisa Ukufinyelela kuhlanganiswe nezinhlelo zokusebenza ezifana ne-Visual Studio, ikakhulukazi uma kunomehluko kubashayeli (isb., abahlinzeki be-OLE DB befa), kungaholela kumaphutha okusebenzisana nenkohlakalo.
- Amafayela amakhulu nokuhlukaniswaNgokusetshenziswa okuqhubekayo, amafayela esizindalwazi angakhula abe mkhulu kakhulu futhi agcwalise izinto zesikhashana, anciphise ukufinyelela futhi abangele ukuphahlazeka.
- Amaphutha athile efayela elingumsizi: Izimo ezinjengamaphutha kumafayela afana ne-“frxque32.mdb”, izingxenye zesikhashana noma amafayela .LDB angasuswanga ngemva kokuvalwa angavimba ukufinyelela noma enze imilayezo yephutha.
Imilayezo yephutha evame kakhulu ekufinyeleleni ngenxa yokufometha noma ukonakala
Kuvamile ukuthi Ukufinyelela kubonise imilayezo efana nalena lapho ubhekene nenkinga:
- “Ifomethi Yesizindalwazi Engaziwa”: Lokhu kuvame ukwenzeka uma izinguqulo zixutshiwe, uma kukhona ukonakala kwefayela, noma uma kunezinkinga zokungenisa idatha.
- “Isizindalwazi sidinga ukulungiswa noma akulona ifayela lesizindalwazi”: Ikhombisa inkohlakalo enkulu kanye nesidingo sokusebenzisa izindlela zokulungisa.
- Iphutha 3343: Ibhekisela kufomethi engaziwa.
- “Isizindalwazi asikwazi ukulungiswa noma akulona ifayela lesizindalwazi se-Microsoft Access”: Ngokuvamile kubonisa umonakalo omkhulu, okunzima ukuxazulula ngezinsiza ezijwayelekile.
Ukubona ikhodi ngqo noma umlayezo kuyasiza ukuqondisa isisombululo esifanele, ikakhulukazi uma kungenxa yezimbangela ezinjengokungahambisani kwenguqulo, ukulimala ngokomzimba, noma ukuntuleka kwezimvume.
Izindlela Eziphezulu Zokulungisa Izizinda Ezigciniwe Zokufinyelela Ezikhohlakele
Isinyathelo sokuqala sihlala njalo yenza ikhophi eyisipele yefayela lamanje ngaphambi kokuzama ukulungisa. Ngemva kwalokho, izenzo ezinconyiwe yilezi:
1. Buyisela kusuka kusipele
Uma unekhophi yakamuva, ibuyisela ifayela elilimele ikhophi enempilo ukugwema izinkinga.
2. Sebenzisa insiza eyakhelwe ngaphakathi ethi "I-Compact and Repair Database".
Ukufinyelela kuhlanganisa a ithuluzi elibizwa ngokuthi "Compact and Repair", kufinyeleleka kumenyu ethi "Amathuluzi Esizindalwazi". Le nqubo:
- Isusa isikhala esingasetshenzisiwe futhi ihlela kabusha idatha, ngokuvamile ilungisa umonakalo omncane futhi ibuyisela ukusebenza.
- Ingenziwa isebenze ngesandla noma ngokuzenzakalelayo lapho uvala isizindalwazi (inketho ethi "Compact on close").
- Kudinga ukuthi kungabikho omunye umuntu osebenzisa ifayela okwamanje nokuthi unezimvume zokubhala kufolda okuyiwa kuyo.
Izinyathelo ezinemininingwane zokusebenzisa ithuluzi:
- Qiniseka ukuthi akekho osebenzisa isizindalwazi nokuthi unezimvume ezanele.
- Vula Ukufinyelela (ungakwenza lokhu ngaphandle kokuvula ifayela elimele).
- Iya kokuthi “Amathuluzi Esizindalwazi” bese ukhetha “Isizindalwazi Esihlanganisiwe Nokulungisa.”
- Khetha ifayela ofuna ukulilungisa; Ukufinyelela kuzodala ikhophi entsha, elungisiwe.
KubalulekileInqubo yokulungisa ingase inciphise idatha ethile. Uma unesipele, ungabuyisa idatha eyengeziwe uma kukhona okushodayo ngemva kwenqubo.
3. Sebenzisa insiza ye-Jet Compact noma i-JetCU40.exe
Uma inketho engenhla ingasebenzi, iMicrosoft inikeza insiza ye-Jet Compact, evumela ukulungiswa okujulile kwamafayela e-MDB/ACCDB awonakele. Kalula nje:
- Landa i-Jet Compact Utility bese uyikhipha.
- Khetha ifayela elilimele njengomthombo kanye nefolda okuyiwa kuyo yesizindalwazi esilungisiwe.
- Chofoza okuthi “Compact” ukuze uqale inqubo.
4. Susa amafayela e-.LDB asele
Lapho usebenza kunethiwekhi, Ukufinyelela kudala amafayela .LDB ukuze alawule ukufinyelela ngesikhathi esisodwa. Uma isizindalwazi sivaliwe ngokungavamile, lawa mafayela angase ahlale futhi avimbe ukufinyelela okwengeziwe. Ukususa lawa mafayela ngaphambi kokuzama ukulungisa futhi kungase kuvule isimo..
5. Ngenisa idatha kusizindalwazi esisha
Esinye isixazululo sithi dala i-database engenalutho futhi ungenise izinto kusuka kwewonakele: Ngenisa idatha ku-Access.
6. Sebenzisa isofthiwe ekhethekile njenge-Stellar Repair for Access
Uma lezi zindlela ezingenhla zingakulungisi ukonakala noma umonakalo mkhulu kakhulu, kunezinhlelo zokusebenza ezihlonishwayo ezivela eceleni njenge Ukulungisa i-Stellar ukuze Ufinyelele, ekwazi ukulungisa amafayela e-MDB ne-ACCDB:
- Ikuvumela ukuthi ukhethe ifayela elimele futhi useshe amafayela onakele ohlelweni.
- Ihlanganisa izinketho zokuskena idatha esusiwe futhi ibonise ukubuka kuqala ngemva kokulungiswa.
- Buyisa amathebula asusiwe, amafomu, imibiko, imibuzo, ngisho namarekhodi ngokukhiqiza ifayela elisha, elinempilo endaweni oyikhethile.
Lezi zinhlelo zokusebenza zingase zikhokhelwe, kodwa ngokuvamile ziyindlela engcono kakhulu yokulondoloza imininingo egciniwe eyonakele kakhulu lapho izinsiza zokufinyelela ezijwayelekile zinganele.
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.