Iyi itsananguro pfupi yezvinokonzeresa "Haisi bhukimaki inoshanda" muMS Access uye zvaunofanira kuita kugadzirisa dambudziko.
MS Access dhatabhesi inopa nzira iri nyore yekugadzirisa marekodhi ebhizinesi. Iko kushandisa kuri nyore kudzidza, uye nekudaro, vashandisi havafanirwe kukwikwidza nemawere ekudzidza curve. Iyo Access database inogona kubata mazana emarekodhi. Saka, kudzoreredza marekodhi nemishumo kunogona kuve basa rinonetesa, kunyanya kana ukafunga kuzviita nemaoko. Apa ndipo panouya mibvunzo yeVBA inobatsira. Iko kukanganisa kuri pamusoro kunogona kuitika kana iwe uchiedza kutsvaga ruzivo kubva kune yako database.
Chii chinokonzera kukanganisa uku
Iwe unogona kusangana nedambudziko iri uchitsvaga marekodhi mudhatabhesi yako uchishandisa VBA mubvunzo, uye iyo Bookmark pfuma inodzosa kukosha kusiri kwayo. Izvi zvinogona kuitika kana marekodhi asina kupihwa bookmark kukosha panguva yekuvhura. Kana iyo bookmark pfuma isiri kushanda sezvaitarisirwa, pane mukana mukuru wekuti faira rako rine huwori. Semuenzaniso, hukama hwezvinhu zvako zve database hunogona kukanganisa.
Pane zvikonzero zvakasiyana-siyana zvinokonzera yakashatiswa Access database. Semuenzaniso, kana faira yako yakakuvadzwa nehutachiona hwekombuta inogona kusashanda semazuva ese. Zvakare, Kupokana kweSoftware nehardware pamushini kunogona kudzivirira dhatabhesi rako kushanda nemazvo. Kukuvadzwa kwemuviri kumudziyo wekuchengetera panochengetwa dhatabhesi kunogonawo kukanganisa dhatabhesi.
Kunyatsotarisisa MS Access Bookmark zvivakwa
Iyo bookmark zvivakwa muMS Access inzira yekufambisa iyo inokutendera iwe kuti uwane marekodhi mumatafura ako e database. Inopa zviziviso zvakasiyana kune rekodhi rega rega paunowana Rekodha seti. Ichi chinokutendera kuti utore uye utore marekodhi kunze kwedhatabhesi uchishandisa VBA zvinyorwa.
The bookmark values haasi zvachose uye ari lost paunopedza chikamu. Nguva inotevera yaunowana marekodhi, iyo Bookmark kukosha ichave yakasiyana. Izvo zvakakosha kuti uzive kuti chete marekodhi mumatafura ane chekutanga kiyi chinhu anogona kuiswa bookmark. Mabhukumaki anopa vashandisi nzira inoshanda yekufambisa kuburikidza nedatabase rekodhi.
Nzira yekugadzirisa sei kukanganisa uku
Paunosangana nedambudziko iri, iwe unoshandisa manyorerwo maitiro kune gadzirisa iyo yakaora Access database. Semuenzaniso, iyo compact uye kugadzirisa nzira inogona kukubatsira kudzoreredza database yako. Nehurombo, izvi zvinoshanda kana uri kutarisana nediki nyaya dzehuori. Kana iyi nzira isingashande, funga kudzoreredza dhatabhesi yako uchishandisa backup faira. Kana iyo backup iri-ku-date, iwe unenge uine dhatabhesi yako uye ichimhanya mumaminetsi mashoma. Zvese zvaunoda kuti uite kutsiva iyo yakakuvadzwa faira nekopi yekuchengetedza dhatabhesi.
Dzimwe nguva, faira rekuchengetedza rinogona kukuvara, kubviswa, kana kusavapo. Pano, iwe unozofanirwa kushandisa yechitatu-bato rekudzoreredza chishandiso senge DataNumen Access Repair. Izvi zvinouya zvinobatsira mukudzorera faira rako rekuchengetedza. Pakusarudza chishandiso chakadaro, zvine hungwaru kusimbisa kuti chinofananidzwa sei nemamwe maapplication mukirasi yacho maererano nekuita. Sezvineiwo, the DataNumen Access Repair chishandiso chinomira pachena nechiyero chekudzoreredza che93.34%. Paunenge uchinge wadzoreredza mafaera ako, unogona kuapinza kune faira idzva uye kudzoreredza database yako.
Wonderful article! Urwu ndirwo rudzi rweruzivo rwunofanirwa kugoverwa kutenderedza internet. Nyarai pakutsvaga injini dzekusaisa chinzvimbo ichi chepamusoro! Huya ushanyire saiti yangu. Thanks =)