Thola ukuthi yini edala umyalezo othi “Iphutha eligodliwe” ku-Access, izindlela zokuwuvikela namathiphu awusizo wokubhekana nale nkinga.
I-MS Access ijwayele ukusetshenziselwa ukwakha amasistimu wedatha ukuze isetshenziswe inhlangano. Ku-most amacala, amabhizinisi amancane ayayisebenzisa ngoba kulula ukuyithola nokuyithumela. Futhi akudingi ukuthi ube namakhono we-IT athuthukile ukuze wazi kahle ukuthi isoftware isetshenziswa kanjani. Njengoba amabhizinisi enweba futhi amarekhodi ezinkampani eba yinkimbinkimbi, most izinhlangano zishintshela kwisoftware ephezulu yedatha.
Ngenhlanhla, ungaxhuma i-database yakho ye-Access nesoftware entsha bese udlulisa amarekhodi sibonga ubuchwepheshe be-Open Database Connectivity (ODBC). Le ndlela yokudlulisa idatha ikuvumela ukuthi ufinyelele idatha kusizindalwazi sakho sokufinyelela usebenzisa ezinye izinhlelo zokusebenza. Ungahlangabezana nephutha elishiwo ngenhla lapho wenza njengokuhlinzwa.
Yini ebangela umlayezo wephutha?
Uma irekhodi ozama ukulisebenzisa usebenzisa indlela ye-ODBC lonakele, impendulo ebekiwe yephutha izovela. Kuzoba nzima ukufunda amarekhodi anjalo. Ngezinye izikhathi lonke itafula lingathinteka, lenze kube nzima kuwe ukufinyelela kunoma yiliphi irekhodi. Ukonakala kwedatha ezingeni lokurekhoda ku-MS Access kuvame ukuhlotshaniswa nemininingwane emikhulu. Ubungozi buyanda lapho inani labasebenzisi balolo lwazi luphakeme khona.
Amarekhodi angonakaliswa lapho ukuxhumana phakathi kwekhompyutha yomsebenzisi neseva hostukufaka i-database kubi. Uma inethiwekhi phakathi komshini womsebenzisi no-hostUkufaka ikhompyutha kuphazanyiswa lapho kwenziwa imiyalo yokubhala, khona-ke irekhodi eliphumela lingonakaliswa.
Ukwakheka kwamatafula akho e-database nakho kungaba nomthelela ekonakaleni kwamarekhodi akho. Isibonelo, ukuba namatafula angakhonjwanga kahle agcina amarekhodi ahlobene nakho kungathinta ukusebenza kahle kwedatha yakho futhi kuholele ekonakaleni kwedatha.
Izindlela zokuvimbela okonakalisa i-database Yokufinyelela amarekhodi
Kuwukuhlakanipha ukuthatha izinyathelo zokuqapha ukuvikela amarekhodi akho e-database ukuthi angonakaliswa. Okwe- starters, qiniseka ukuthi inethiwekhi yakho iphephile futhi isebenza kahle. Yenza amasheke avamile bese ushintsha noma iyiphi i-hardware elimele. Ungatshala futhi ohlelweni lokulondoloza amandla ukuvimbela ukunqamuka kukagesi kungazelelwe, ngakho-ke uqinisekisa ukuthi akukho ukuvalwa okungazelelwe kwedatha yakho.
Lapho uhlela i-database, bheka izindlela ezinhle eziqinisekisa ukusebenza kahle kwedatha yakho. Ngaphezu kwalokho, hlanganisa futhi ulungise i-database yakho ngezikhathi ezithile ukuyivimba ukuthi ingabi ngaphezulu.
Okufanele ukwenze lapho uhlangabezana naleli phutha
Uma uhlangabezana naleli phutha, kuzodingeka ukuthi ukhombe ukuthi yiliphi irekhodi elilenzayo. Ungakufezekisa lokhu ngokuskrola kumathebula athintekile nangokukhomba ngesandla amarekhodi alimele. Kodwa-ke, le yinqubo eyisicefe, ikakhulukazi lapho ubhekene nemininingwane emikhulu. Kulokhu, cabanga ukusebenzisa umbuzo we-VBA ukukhomba amarekhodi athintekile. Lapho usukhombe amarekhodi athintekile, susa amarekhodi, bese usebenzisa amafayela wakho wokusekelayo ukuwafaka esikhundleni sawo.
Lapho amarekhodi alimale kakhulu futhi kungekho nesipele esitholakalayo, kubaluleke kakhulu ukusebenzisa uhlelo lokusebenza olufana ne- DataNumen Ukulungisa Ukufinyelela ithuluzi lokuthola idatha ekhohlakele. Into enhle ngokusebenzisa leli thuluzi ukuthi ungabuyisa amarekhodi asusiwe. Ngemuva kokuthola izinto ezithintekile, zidlulisele kufayela elingenalutho bese ubuyisela i-database yakho. Ngaso sonke isikhathi yenza ikhophi lefayela elonakele ngaphambi kwakhotart inqubo yokutakula. Lokhu kunikeza uhlelo lokubuyela emuva uma wehluleka ukubuyisa ifayela le- tarthola amarekhodi.
Bengisebenzisa i-inthanethi ngaphezu kwamahora angu-3 kamuva nje, kodwa angikaze ngithole noma iyiphi i-athikili ethakazelisayo njengeyakho. Kuyigugu elithandekayo kimina. Ngokubona kwami, uma bonke abanikazi bewebhusayithi kanye nama-blogger benza izinto ezinhle zokuqukethwe njengoba kungenzeka wenze, iwebhu izoba wusizo kakhulu kunangaphambili.