MS Access MDB chigadziro chekugadzira
Kugadzirisa MDB faira
Kunyange kana isu tose tichibvumirana kutaura kuti database yeAccording haifaniri kuvapo yekubata zvinopfuura 2GB yedheta, asi inogona kuitika kune zvimwe zvikonzero zvaunopedzisa ne database yakadai (Fig 1).
Somuenzaniso, paunenge uchitora demo rekunze mune dhesi, mushure mokubvisa matafura muFaira reFair, iwe unofanirwa kugadzirisa nekugadzirisa iyo kuitira kuti uchenese cache, uye kuderedza filesize.
Kunyange zvakadaro, ne 2GB Access file (Fig 1), paunoedza kuigadzirisa nekugadzirisa (Figi 2), unopedzisira uine kukanganisa Nharo isina kukodzera (Figu 3), iyo inokuudza kuti database yakakura zvikuru akabatanidzwa - inodarika simba rakapiwa filesize.
Gadzirisa yakaipa Access database
Mhinduro iyo yandinokuraira kuti uwane database yako yakadzoka iri nyore kwazvo, ndeyeimwe nzvimbo yekuDhina yekudhani, CompactAndRepairDB-vX.0.mdb [1], iyo ichakubvumira kuti uenzane uye kugadzirisa yekutanga.
Kutanga, sekugadzirisa maitiro kwakatangwa asi kusati kwapera, unofanirwa kuve nechokwadi chokuti hauzoperi nemashoko ekukanganisa Table TempMSysAccessObjects yavapo. (Mufananidzo 4).
Kuti uite kudaro, enda pane zvaunosarudza, uye chengeta bhokisi rakanzi Zvimwe zvinhu (mufananidzo 5), iyo icharatidza tafura ye TempMSysAccessObjects (Figu 6), yaunofanira kubvisa kuitira kuti usatora mhosho yako kana iwe uchingopindirana database (Fig 4).
MS Acces MDB kugadzirisa
Zvadaro, teerera faira CompactAndRepairDB-vX.0.mdb [1], vhura, uye uwane nzira yako macros chikamu (Fig 7). Tora kaviri pamutauro wako waunofarira (shanduro, chiFrench, chiPolish, Spanish), uye shandisa zita rakakwana refaira rako, nzira yakaiswa (Fig 8).
Tsvaga kuenzanisa uye kugadzirisa faira iri kushandiswa
Zadza ipapo zita rose rekuenda kwedata rakagadzirwa (Fig 9), iro richaponeswa mumudzidzi weC directory C: \.
Access access database repair toolware freeware
Zvechokwadi, iyi nzira inoda iripo iri faira faira, iyo inotariswa nekuda kwekhodi ye Allen Browne [2].
Matanho uye zvikwereti
CompactAndRepairDB-v1.2.mdb, Yoann Bierling, Access database compact uye kugadzirisa chinhuFiripi iripo, Allen Browne, Access access check check files - http://allenbrowne.com
Bhuku rekugadzira MDB
Kana zvisingakwanisi kuvhura MSAccess database faira, nokuti pane kukanganisa kunokandwa ne-software, somuenzaniso kana uzarura MS Access 2GB file, iyo inosvika kumiganhu, zvakanakisisa ndezvekutora MS Access refaira rekugadzirisa, iyo ichaita kuAccac compact and repair operation kubva kunze kwe database.
Iva excel Pro: Joinha kosi yedu!
Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.
Nyoresa pano
Kugadziriswa uye kugadziriswa Kuwana kunogona kuitwa kune imwe kunze uye yakasvibiswa Access database file MDB, uye iyi MDB faira kugadzira Access file ichabatanidza Access database nekuigadzirisa kana zvichibvira.
Iwe unogadzirisa sei uye kugadzirisa dheseti mu Access? Kana iwe uchikwanisa kuzarura faira, enda pane zvishandiso zvemenu> zvigadzirwa zvepa database> compact uye repair database.
MS Access mafaira yekugadzirisa chigadzirwaKuwanika kusingazivikanwi kwekodhidhi yepamusoro
Kana uchinge uchinge uchitadza zvisiri izvo zvinyorwa zvisiri izvo, pane mikana yakawanda yekuedza, sezvo chikonzero chinogona kubva kune zvikonzero zvakasiyana:
- Iva nechokwadi chokuti file ye database yakasvinudzwa nekodzero yeMSAccess software. Kana izvo zvisina kudaro, edza kuisa dheedhi panzvimbo yekuizarura, nokuenda pane faira> zvasarudzo> general> kugadzira databases> nhepfenyuro itsva yekuronga kurongeka, kutarisa kuti zvirongwa zvakarurama, kuve nechokwadi kuti sarudzo ye nhaka inotariswa, uye kushandura dhesiyo kuti ive yakarurama.
- Iva nechokwadi chokuti software yeMSAccess iri kushanda zvakanaka, uye inoshandisa chero iripo rekusimbisa mafaira uye service pack. Edza kusika nekuchengetedza database yekare, ivhare uye iivhure zvakare.
- Ita chigadziro uye kugadzirisa kubva kune MSAccess software muzvigadzirwa> database utilities> database yekugadzirisa uye yekugadzirisa.
- Edzai kunze kwekugadzirisa uye kugadzirisa nekushandisa purogiramu yedu yekudzivirirwa, shanduro yekugadzirisa database yeSMS Access, iyo inogona kugadzirisa faira MDB uye kugadzirisa dhiyabhorosi yeDBB kubva kunze, kunyanya kushandiswa kugadzirisa MS Access 2GB mafaira uye pamusoro, apo iwe haugone kuvhurazve.
MS Access chigadziro chekodhina chekushandisaMibvunzo Inowanzo Bvunzwa
- Ndedzipi sarudzo dziripo dzekugadzirisa iyo yakashatiswa yeMDB faira muMicrosoft Access yekudzosera data yakaoma?
- Vashandisi vanogona kushandisa iyo compact uye kugadzirisa chimiro muMicrosoft kuwana kuyedza kugadzirira mafaira akaora mafaira eMDB. Kana iyo ikatadza, yechitatu-bato yeMDB yekugadzirisa zvinhu inogona kupa mamwe maitiro epamberi ekugadzirisa
Yoann Bierling ibhusaiti yekushambadzira & Dhijitari Kukurukurirana Professional, kugadzira kukanganisa kwepasi rose kuburikidza nehunyanzvi uye hunyanzvi mune tekinoroji. Passionate nezve kupa simba vanhu uye masangano kuti akubudirire muzera redhijitari, anofambiswa kununura mhedzisiro yakasarudzika uye yekufambisa ichipfuura kuburikidza nedzidziso yezvinyorwa zvemukati.
Iva excel Pro: Joinha kosi yedu!
Simudza hunyanzvi hwako kubva kuLovice kuenda kuHamba NeGamba Pedu 365 Basics Course, rakagadzirirwa kukuita iwe nyanzvi mune zvikamu zvishoma.
Nyoresa pano