Ungaxazulula kanjani “Izinguquko ozicelile etafuleni aziphumelelanga ngoba zizokwakha amanani ayimpinda”

Ezinsukwini zanamuhla post, sizohlola ukuthi yiziphi “izinguquko ozicelile etafuleni ezingaphumelelanga ngoba zizodala amanani ayimpinda” kusho iphutha, kubangelwa yini, nezindlela ezisebenzayo zokulixazulula.

Ungaxazulula kanjani “Izinguquko ozicelile etafuleni aziphumelelanga ngoba zizokwakha amanani ayimpinda”

Amandla kwanoma iyiphi i-database yokukhomba irekhodi ngalinye ngokuhlukile enza ukuthi abasebenzisi bakwazi ukuguqula amarekhodi. Kodwa-ke, uma uthola impendulo ekhombisa iphutha elingenhla, awukwazi ukusebenzisa amarekhodi akho wedatha ngaphandle kokuthi ubhekane nenkinga.

Kusho ukuthini leli phutha

Izinguquko ozicelile etafuleni aziphumelelanga ngoba zizokwakha amanani ayimpinda

Njengoba impendulo yephutha isikisela, kwenzeka lapho ufaka irekhodi elisha etafuleni elinenkomba ye-AutoNumber. Kujwayelekile futhi ezimweni lapho ukuhlwanyelwa kwenkambu yenkomba kungenziwa kahle. Lokhu kwenza inkambu ye-AutoNumber inikeze amanani angavumelekile kumarekhodi akho asanda kudalwa. Ngakho-ke, awukwazi ukufaka amarekhodi angeziwe kudathabheyisi yakho futhi lokhu kukwenza kungabi namsebenzi kokuthengiselana okuzayo.

Yini engaba nesandla kuleli phutha?

Izizathu ezahlukahlukene zingadala iphutha elingenhla njengoba kuxoxwe ngezansi.

1. Iziphazamisi ku-JET Database Engine

Injini yedatha ye-JET iyasiza ekuphatheni nasekuphatheni i-database ehlobene. Inomsebenzi wokuqinisekisa ubuqotho bedatha nokusebenza kokuthengiselana, phakathi kwezinye izinto. Ukuqinisekisa ukuthi lokhu kuyenzeka, konke okwenziwayo kufanele kube okuhlukile, okuthile okutholwe ngokukhomba ngokulandelana kokhiye oyinhloko kuthebula ledatha.

Uma injini ye-JET ingenakuqinisekisa ukukhonjiswa okuhlukile kwamarekhodi, izinkinga zizokwenzeka nakanjani. Isibonelo, i-bug enguqulweni yesine yenjini yedatha ye-Microsoft JET yaziwa kakhulu ukudala amaphutha ekuhlwanyeleni insimu ye-AutoNumber ku-most amatafula wedatha. Ukugwema lokhu, kungakuhle ukuthi ube nephakethe lensiza ye-JET esesikhathini.

2. Ukwakhiwa kwesizinda semininingwane esingesihle

Idizayini engalungile ingahle ibe phakathi kwesithiyo esikhulu ekusebenzeni kahle kwedathabheyisi. Amanye amaphutha wedizayini akwazi ukuqala iphutha elingenhla afaka ukuxhumanisa i-subform nefomu eliyinhloko etafuleni ukuze bobabili bakwazi ukuguqula inkambu ye-AutoNumber. Lokhu kusho ukuthi okufakiwe kuwo womabili amafomu nefomu eliyinhloko kufakwa njengamarekhodi amasha etafuleni. Futhi, uma usetha i-AutoNumber njengenani elingahleliwe, kukhona amandla okuphindaphinda amarekhodi.

3. Inkohliso yeDatabase

Enye imbangela ejwayelekile yephutha elingenhla ngu Finyelela inkohlakalo yedatha. Inqwaba yezinkinga ezinjengokungqubuzana kwesoftware, ukubhaliswa kwamakhompiyutha okonakele, ukunqamuka kukagesi kungazelelwe, noma amagciwane ekhompyutha kungadala ukonakala kwedatha.

Okufanele ukwenze lapho ubhekene naleli phutha

Ukulungisa le nkinga unomphela, kuzodingeka wenze ukuxilongwa okunembile kwembangela. Start ngokuhlaziya umlando wedathabheyisi yakho ukukusiza ukuthola noma yiziphi izingqinamba ezisenkingeni. Isibonelo, uma i-database yakho isha sha futhi awenzanga ukuhlolwa okuphelele, lapho-ke kunethuba lokuthi imbangela yinkinga yokuqamba hhayi inkohlakalo yedatha. Kulokhu, cwaninga ukwakheka kwamafomu akho bese uqinisekisa ukuthi izinkambu ze-AutoNumber zine- “New Records” ne- “Field Size” isethwe ku- “Increment” kanye ne- “Long Integer”, ngokulandelana.

Ehlangothini le-flip, uma i-database yakho ibisebenza isikhathi eside bese kuthi izingqinamba zibonakale ngemuva kokuvuselelwa kwenjini yedatha ye-JET, cabanga ngomsebenzi we-MS Access wokulungisa nokulungisa ukusetha kabusha imbewu ye-AutoNumber ku-database yakho. Manje, faka inguqulo ezinzile yenjini ye-JET kukhompyutha yakho. Lokhu kufanele kulungise inkinga.

Uma usebenza nedatha eyonakele, sebenzisa i- DataNumen Access Repair isoftware yokuthola amafayela wakho. Manje, woza ne-database entsha bese uyinika igama elihlukile. Ungahambisa amafayela abuyiselwe kudathabheyisi esanda kwenziwa. Manje une-database yakho esebenzayo.

DataNumen Access Repair

Impendulo eyodwa kokuthi “Indlela Yokuxazulula “Izinguquko ozicelile etafuleni aziphumelelanga ngoba zizodala amanani ayimpinda””

  1. Sawubona! Ngiyazi ukuthi lokhu akusekho esihlokweni kodwa ngicabange ukuthi ngizobuza. Ungathanda ukushintshanisa izixhumanisi noma mhlawumbe isivakashi esigunyaza ibhulogi post noma ngokuphambene? Iwebhusayithi yami ihlanganisa izihloko eziningi ezifanayo nezakho futhi ngicabanga ukuthi singazuza kakhulu komunye nomunye. Uma ungaba nentshisekelo zizwe ukhululekile ukungithumelela i-imeyili. Ngibheke phambili ekuzwenicngawe! I-blog enhle kakhulu ngendlela!

shiya impendulo

Ikheli lakho le ngeke ishicilelwe. Ezidingekayo ibhalwe *