Iyo databases ye Microsoft Access ivo a tool inoshandiswa zvakanyanya mubhizinesi uye nharaunda dzemunhu kubata mavhoriyamu makuru yeruzivo. Nekudaro, nekufamba kwenguva, mafaera aya anogona kushatiswa nekuda kwezvinhu zvakasiyana, kukanganisa iyo kutendeka yedata uye kuita kuti zviome kuwana. To avoid the kurasikirwa yeruzivo, zvakakosha kuziva uye kushandisa nzira kugadzirisa uye kudzivirira huwori databases mu Access.
Muchikamu chino, tichaongorora zvakadzama zvinokonzeresa common Access uori nyaya, nzira kugadzirisa dhatabhesi akakuvadzwa, uye anokurudzirwa matanho kudzivirira matambudziko ramangwana. Isu tichatarisawo kune akasiyana maturusi aripo ekudzoreredza data kana a mhosva yakakomba.
Zvikonzero nei iyo Access database inogona kushatiswa
Pane zvikonzero zvakati kuti nei Access database inogona kushatiswa. Zvimwe zvezvinonyanya kuzivikanwa zvinosanganisira:
- Zvikanganiso mubhinari fomati yemafaira: Chero kukanganisa mu chimiro chemukati yedatabase faira inogona kuita kuti isasvike.
- Kuvharwa kusingatarisirwi: Kupindirana kuparara kwehurongwa, kumanikidzwa kuvhara kana kuparara kweapp panguva ye data kunyora zvinogona kukonzera huori.
- Hardware matambudziko: Bad sectors mu hard drive kana zvikanganiso zvetiweki zvinogona kukanganisa kutendeseka kwemafaira.
- Shandisa muzvirongwa zvisina kutsigirwa: Edza kuvhura MDB kana ACCDB mafaera ne maapplication asina kugadzirwa Izvi zvinogona kuita zvikanganiso.
- Utachiona kana hutachiona hwehutachiona: The kombiyuta kurwisa Vanogona kugadzirisa chimiro chefaira uye kuita kuti dzisasvike.
Maitiro ekugadzirisa Dhatabhesi Yakaora muMicrosoft Access
Kana iyo Access dhatabhesi yakashatiswa, pane akati wandei nzira dzatinogona kushandisa kuyedza kuidzosera:
1. Shandisa Compact uye Repair tool
Microsoft Access ine a yakabatanidzwa basa kugadzirisa uye kugadzirisa dhatabhesi dzakaora. Kuti uishandise, tevera matanho aya:
- Vhura Microsoft Access pasina kurodha database yakakuvadzwa.
- Pahwindo guru, tinya Archive > mikana.
- Sarudza iyo tab Yazvino database uye shandisa sarudzo Compact on close.
- Kana iyo database isingavhure, sarudza Database zvishandiso > Compact uye kugadzirisa database.
- Sarudza iyo yakakanganiswa MDB kana ACCDB faira uye rega Access iedze gadzirisa.
2. Dzosera kubva kune backup
Kana dambudziko rikaramba riripo, iyo yakanaka ndeye dzosera ichangoburwa backup yedatabase faira. Zvinogara zvichikurudzirwa kuita nguva dzose backups kudzivirira kurasikirwa kwemashoko.
3. Pinza data mudura idzva
Kana iyo yekugadzirisa isingashande, imwe nzira ndeyekugadzira dhatabhesi nyowani muAccess uye edza kupinza iyo data. data kubva kune yakaora database.
- Vhura Microsoft Access uye gadzira dhatabhesi nyowani isina chinhu.
- Sarudza Data yekunze > kupinza.
- Sarudza iyo yakaora faira uye sarudza iyo matafura nezvinhu kuti unoda kupora
- Ngenisa iyo data uye simbisa yayo kutendeka.
4. Shandisa zvishandiso zvechitatu-bato
Kana nzira dziri pamusoro apa dzakakundikana, dziripo mapurogiramu chaiwo muKuwana dhatabhesi kudzoreredza, senge Stellar Repair yeKuwana kana Wondershare Recoverit. Zvishandiso izvi zvinogona kugadzirisa mafaira akakuvadzwa uye kudzoreredza ruzivo rwakarasika.
Mazano ekudzivirira huwori Access database
Kudzivirira dhatabhesi reAccess kubva pakusvibiswa mune ramangwana, zvinokurudzirwa kutevedzera mamwe maitiro akanaka:
- Gadzira ma backups enguva dzose: Kuchengetedza vhezheni yapfuura yedhatabhesi kunokubvumira kuti uidzorere kana paita huwori.
- Kamura dhatabhesi: Kupatsanura data uye mushandisi interface mumafaira akasiyana kunoderedza njodzi yehuori.
- Dzivisa kuvhara Access pakarepo: Gara shandisa iyo chaiyo yekubuda sarudzo kudzivirira huwori hwefaira.
- Shandisa yakagadziridzwa antivirus software: Kuchengetedza komputa yako kunoderedza njodzi yehutachiona inogona kukanganisa mafaera ako.
- Seta Access kuti iite otomatiki compact: Gonesa sarudzo ye compact pakuvhara inobatsira kuchengetedza dhatabhesi rine hutano.
Microsoft Access MDB uye ACCDB mafaera anojaira kukuvara nekuda kwezvikonzero zvakawanda, asi kune akasiyana maturusi uye nzira dzinogona kubatsira kugadzirisa matambudziko aya pasina kurasikirwa akakosha data. Nekutevera nzira dzakakodzera, zvinokwanisika kuderedza njodzi yehuori uye kuchengetedza dhatabhesi inoshanda nekufamba kwenguva. Govera gwara iri kuti vamwe vashandisi vadzidze kuzviita.