Yuav Paub
- Nrog cov database qhib hauv Access, xaiv File > Clos > Database cuab yeej > Compact and Repair Database.
- Niag rau hauv cov ntaub ntawv koj xav kom compact thiab kho. Xaiv Compact. Muab lub npe rau lub compacted database. Xaiv Txuag.
- Txheeb xyuas cov ntaub ntawv compacted ua haujlwm zoo, tom qab ntawd tshem tawm cov ntaub ntawv qub.
Lub sijhawm dhau mus, Microsoft Access databases loj hlob tuaj thiab tsis tas siv qhov chaw disk, yog li nws yog ib lub tswv yim zoo los khiav cov cuab yeej sib cog lus thiab kho cov ntaub ntawv kom ntseeg tau qhov sib xws ntawm koj cov ntaub ntawv. Nov yog yuav ua li cas thiaj li siv Access rau Microsoft 365, Access 2019, Access 2016, Access 2013, thiab Access 2010.
Yuav ua li cas txhawm rau thiab kho cov ntaub ntawv nkag mus
Ua ntej koj pib, xyuas kom koj muaj cov ntaub ntawv thaub qab tam sim no. Compact thiab kho yog ib tug heev intrusive database lag luam thiab muaj peev xwm ua rau database tsis ua hauj lwm. Cov thaub qab yuav yog qhov cuab yeej yog tias qhov no tshwm sim.
- Yog tias cov ntaub ntawv nyob hauv ib daim ntawv qhia, qhia lwm tus neeg siv kom kaw cov ntaub ntawv ua ntej pib ua haujlwm. Txhawm rau khiav lub cuab yeej, koj yuav tsum yog tib tus neeg siv nrog cov ntaub ntawv qhib.
- Xaiv File thiab xaiv Kaw yog tias koj muaj cov ntaub ntawv qhib rau hauv Access window.
-
Xaiv lub Database cuab yeej tab.
Image -
Xaiv Compact and Repair Database in the Tools group.
Image -
The Database rau Compact From dialog box yuav qhib. Nkag mus rau hauv cov ntaub ntawv koj xav kom compact thiab kho thiab xaiv Compact.
Image -
Muab lub npe tshiab rau cov ntaub ntawv compacted hauv Compact Database rau hauv dialog box, ces xaiv lub Save khawm.
Image - Tom qab paub tseeb tias cov ntaub ntawv compacted ua haujlwm tau zoo, tshem tawm cov ntaub ntawv qub thiab hloov npe cov ntaub ntawv compacted nrog tus thawj database lub npe. (Cov kauj ruam no yog xaiv tau.)
Nco ntsoov tias kev sib cog lus thiab kho tsim cov ntaub ntawv database tshiab. Yog li ntawd, ib qho NTFS cov ntaub ntawv tso cai uas koj tau thov rau qhov qub database yuav tsis siv rau cov ntaub ntawv compacted. Nws yog qhov zoo tshaj plaws los siv cov neeg siv qib kev ruaj ntseg es tsis txhob tso cai NTFS vim li no.
Nws tsis yog lub tswv yim phem los teem sijhawm ob qho tib si thaub qab thiab kev cog lus / kho cov haujlwm kom tshwm sim tsis tu ncua. Qhov no yog ib qho haujlwm zoo heev los teem sijhawm rau hauv koj cov phiaj xwm kev tswj xyuas cov ntaub ntawv.
Vim li cas Compact thiab Kho Access Databases?
Ib ntus compacting thiab kho Access databases yog tsim nyog rau ob qho laj thawj.
Ua ntej, Nkag mus rau cov ntaub ntawv database loj hlob tuaj raws sijhawm. Qee qhov kev loj hlob no yuav yog vim cov ntaub ntawv tshiab ntxiv rau hauv cov ntaub ntawv, tab sis lwm qhov kev loj hlob yog los ntawm cov khoom ib ntus uas tsim los ntawm cov ntaub ntawv thiab tsis siv qhov chaw los ntawm cov khoom raug tshem tawm. Compacting lub database reclais qhov chaw no.
Thib ob, cov ntaub ntawv database tuaj yeem ua tsis zoo, tshwj xeeb yog cov ntaub ntawv uas tau nkag los ntawm ntau tus neeg siv dhau ntawm kev sib koom ua ke. Kho cov ntaub ntawv kho cov ntaub ntawv kho cov teeb meem kev noj nyiaj txiag uas tso cai rau kev siv txuas ntxiv thaum khaws cia kev ncaj ncees ntawm database.
