ä»ãã10幎以äžåãèªåãä»å°ã«ããé äœã£ãŠãAccessã§å€æ 管çãããããã°ã©ã ã«ãªããŸããåœæã¯ã¯ã©ãŠããASPãšåŒã°ããäžéšã®ãµãŒãã¹ãããªãããŸãã¹ããã©ããªãæ代ãã¿ã€ã ã«ãŒãã§å€æ 管çãããŠãããŸããããã ãå ¶ã®æéã¯çµæ§ãªãã®ã§ãæ絊ååŸç®¡çãåæåºå€ç®¡çãªã©ããããExcelã§äœæ¥ã¯èŠçã§ããã
ãšããããšã§ãã€ãã£ãã®ãã³ã¬ããã ãåœæ䜿ã£ãŠããã·ã¹ãã é£æºçšã®æ©èœã¯åé€ããäžæ¹ã§çŸä»£çšã«ã¡ãã¥ãŒçã¯ãªãã³åãããã®ã«ãªããŸããäžéšã®æ©èœïŒPDFé£ç¶å°å·ïŒã¡ãŒã«éä¿¡ïŒã«ã€ããŠã¯ãªã¡ã€ã¯ãå¿ èŠãªã®ã§ãçŸåšã¯æ©èœãšããŠåæ¢ãããŠãããŸããããŸãäžéšã¯æ§æ¥ã®ã©ã€ãã©ãªã䜿ã£ããã®ã«ãªã£ãŠãã®ã§ãçŸåšããã眮ãæãäžã
â»æ¬ã¢ããªã¯å®éçšãšããããã¯ãAccessã®å匷ã®ããã«ã±ã«ãªãã°ãšæãã¢ããããŠããŸããäžå¿å®éçšããŠãããã°ã©ã ãªã®ã§ã䜿ããªãã¯ãªãã§ãããäŒç€Ÿã®èŠå®ãã«ãŒã«ã«ãã£ãŠã¯æ©èœã®è¿œå å®è£ ãå¿ èŠã§ãããã
ç®æ¬¡
ããŠã³ããŒã
ZIPã§åºããŠãã ãã§ããäžã«ã¯ä»¥äžã®ãããªãã¡ã€ã«ãå ¥ã£ãŠããŸãã
- willson.accdb - ããã°ã©ã ã®æ¬äœã§ããããŒãã«ã¯å¥ã®ãã¡ã€ã«ãžãšãªã³ã¯ããŒãã«ã§ç¹ãã§ããŸãã
- base.accdb - ãã¹ã¿ãŒãããŒã¿é¡ãæ ŒçŽããŠããã¡ã€ã«ãèµ·åæã«èªåçã«ãã®ãã¡ã€ã«ãžã®ãªã³ã¯ããŒãã«ã§æ¥ç¶ãããŠãŸãã
- base1.accdb - 空ã£ãœã®ãã¡ã€ã«ãããã¯ã¢ãããã¡ã€ã«äœææã«ãããžããŒãã«ãã³ããŒããŠå§çž®ããŸãã
- 7-zip32.dll - ZIPå§çž®ã®çºã®é«æ©èœã©ã€ãã©ãªãbase1.accdbãå§çž®ããŠä¿åããŸãã
ãŸããæ¬ããã°ã©ã ã¯ã32bitçAccessã§åäœããŸãã®ã§ãRuntimeã¯32bitçããå©çšãã ãããåäœã¯ãAccess 2010, 2013, 2016ã§ç¢ºèªããŠããŸãã
äž»ãªæ©èœ
ååèµ·åæã«äžåãã³ã³ãã³ãã®èš±å¯ãæ±ããããŸããèš±å¯ãäžããªããšVBAãå®è¡ã§ããŸãããå€ãããã°ã©ã ã§ã¯ãããŸãããåœæã®æ§ã ãªããŠããŠãè©°ã蟌ãã§ãŸãã
ããã°ã©ã ã®èšå®
ããã§ã¯ãããã°ã©ã ã®åæèšå®ãè¡ããŸããäœããçŸåšã¯SMTP Server Addressãªã©ã®ã¡ãŒã«é¢ä¿ã¯æ©èœãæ¢ããŠããŸãïŒåœæBASP21ã§éä¿¡ããããŠããŠããŸããããããå æžå€ãã®ã§ãçŸåšã¯å¥ã®æ段ãæ§ç¯äžïŒãå¿ ãèšå®ããŠããå©çšããŸãããããšã©ãŒãåºãŸãã®ã§ïŒãšã©ãŒãã©ãããšãåœæãªããããŠãªãã£ãã»ã»ã»ïŒ
- 管çç¯å²ã¯è·å¡ãã¹ã¿äžã§èšå®ããçµçæå Žã³ãŒãã«åºã¥ããŠèšå®ããŸããããã§ç®¡çç¯å²ãçµããšãè·å¡ãã¹ã¿äžã«ã¯åºçŸããªããªãã®ã§æ³šæãå¿ èŠã§ãã
- åäŒååŸé床æ¥æ°ãèšå®ãããšãåäŒç»é²æã«å¶éãæãããŸããå°±æ¥èŠåã«ä¹ã£åãèšå®ããããšè¯ãã§ãããã
- 幎éèŠåæåºå€æ¥æ°ã¯ã1幎éã§å¿ èŠãªåæåºå€æ¥æ°ãèšå®ãããã®ã§ããå®å šé±äŒäºæ¥å¶ã®å Žåã«ã¯äžèŠã§ãããã
- å°å·äœçœ®èª¿æŽã¯ãã¢ããAã¿ã€ã ã«ãŒãã§å°å·ãããæã®ããªã³ã¿æ¯ã®ãºã¬ãè£æ£ããçºã®èšå®ã§ãã瞊äœçœ®æšªäœçœ®ãmmã§æå®ããŠèª¿æŽããŸãããã
- åæåºå€æ¥ãã§ãã¯ã¯çµäºæã«åæåºå€æ¥æ°ããŒã¿ããã§ãã¯ããæ©èœã§ãã
- ã¿ã€ã ã«ãŒãå°å·ã»ã³ã¿ãªã³ã°ã¯äœ¿ããªããšæããŸãããå°å·äœçœ®ãã»ã³ã¿ãªã³ã°ããäžã§èª¿æŽããå Žåã«å©çšããŸããéåžžã¯ãªãã§åé¡ãªãã
å³ïŒæ©èœåæ¢ãããŠãèšå®ããã
ããŒã¿ã®ããã¯ã¢ãã
æ¢åã®base.accdbãå§çž®ããæå·åZIPãšããŠåºåã»åã蟌ã¿ããçºã®æ©èœã§ãããã¡ã€ã«ã®æ¡åŒµåã¯rouãšããŠèšå®ããŠããŸããæè¿ã§ããAccessã¯ãã¡ã€ã«ãç ŽæããªããªããŸããããããŒã¿ã®èª€ã£ãåé€ãæ倱ã«åããŠãéäžããã¯ã¢ãããåã£ãŠãããšè¯ãã§ãããã
ãŸããåã蟌ã¿ãè¡ããšæ¢åã®ããŒãã«ããŒã¿ã¯å šãŠåé€ãããŸãã®ã§ãã€ã³ããŒããããæã¯æ³šæãå¿ èŠã§ããäœãããã®ããã°ã©ã ã¯ãèµ·åæã«èªåã§5äžä»£ã«æž¡ã£ãŠããã¯ã¢ãããã«ã¬ã³ããã£ã¬ã¯ããªã«äœã£ãŠããŸãã®ã§ããã¡ããã埩垰ãå¯èœã§ãã
ãŸããããããExcelåºåã§ã¯ãäž»èŠãªããŒãã«ã®ããŒã¿ãxlsx圢åŒã§åºåããäºãã§ããããã«ãªã£ãŠããŸããããŒã¿ã®äºæ¬¡å©çšãªã©ãèããŠããå Žåã«ã¯ãã¡ãããããŒã¿ãåºåããŠå©çšãããšè¯ãã§ãããã
幎床æŽæ°ã®å®æœ
幎床æŽæ°ã¯ãæ§å¹ŽåºŠã®ããŒã¿ãã以äžã®ããŒã¿ãæ°å¹ŽåºŠãšããŠåŒãç¶ããŸãã
- æªæ¶åãšãªã£ãŠãäŒæ¥åºå€ããŒã¿ãåŒãç¶ããŸãã
- æ¶åæžã¿ã®äŒæ¥åºå€ããŒã¿ã¯æ¶æ» ããŸãã
- äŒç€Ÿã®å¶åºŠã«ãã£ãŠéããšæãããã®ã§ã幎åã®æ絊äŒæä»äžæ¥æ°ããã³æ§å¹ŽåºŠã§ã®æªå©çšæ絊äŒæã®é·æçé€äŒæãžã®ç©ç«ã«ã€ããŠã¯éçšãå¿ èŠã§ãã
è·å¡ãã¹ã¿ãŒäžèŠ§
幎äŒçã®åºæ¬ããŒã¿ãäžèŠ§è¡šç€ºã§ç·šéå¯èœã«ããŠããŸãããã¡ãã¯åå¥ã§ã¯ãªãã®ã§ãç·šéå¯èœé ç®ã¯å¿ èŠæäœéã§ããäžèŠ§ã§ç¢ºèªãããå Žåã«å©çšããŸãã
å³ïŒãããæ°ããæ¹åŒã«å€ããããšæã£ãŠãŸãã
ã¡ã€ã³ç»é¢
å€æ 管çç»é¢
æ¬ããã°ã©ã ã®ã¡ã€ã³ç»é¢ãè·å¡ã³ãŒããåå¥ã®åæ¥åºå€ã»æ絊ååŸã®ããŒã¿ãç»é²ããŸãããŸããµãæ©èœãšããŠãã¿ã€ã ã«ãŒãå°å·æ©èœãã¬ããŒãå°å·æ©èœããããŸããçŸåšã¯ããã€ãã®æ©èœã¯äžå¯èŠã«ããŠãããŸãïŒAccess2016以éã§åãããã«äœãçŽããå¿ èŠã§ããããã»ã»ã»å ãAccess97ã§ããããããªãå·®ããããŸããïŒã
- ã¿ã€ã ã«ãŒãäœæã«ãã§ãã¯ãããããšã¿ã€ã ã«ãŒãå°å·å¯Ÿè±¡ã«ãªããŸãã
- éè·ã«ãã§ãã¯ãããããšè¡šç€ºãããªããªããŸãã
- ã¡ãŒã«éä¿¡ã¯ãã§ãã¯ãå ¥ãããšäžæ¬éä¿¡ã®å¯Ÿè±¡ã«ãªããŸãããçŸåšã¯äœ¿çšã§ããŸããã
- äžå¿ãåäŒã ãã§ãªãæéäŒã®èšå®ã察å¿ãããŸããã
- åæåºå€ãäŒæ¥åºå€ãšãã®æ¯æ¿ãªã©ã«é¢ããé ç®ãäžã®ããã«ã«ãªããŸãã
- å³äžã®éçããŒã¯ã§æå ŽïŒæ¯åºãªã©ãéšçœ²ã§ã®ã³ãŒããšååïŒãç»é²ããŸããå¿ ãèšå®ããããã«ããŸãããã
å³ïŒExcelã§ã¯ãããã£ã管çã¯æ¬åœã«èŠçã§ããã
ã¿ã€ã ã«ãŒãå°å·
ãŸããã¿ã€ã ã«ãŒãã¯ã¢ããAã¿ã€ãã«å¯Ÿå¿ãæã¯ãããå€åã§äºåã«åææ¥ããæ¥ææ¥ããç¥æ¥ãããæŒããŠçšæããŠããŸããããã®ãããæéã§ãããããã ãçŸä»£ã«æŒããŠã¯ãã®æã®åºéå€ç®¡çã¯ãã¯ãFelicaã䜿ã£ããã®ãäž»æµïŒããã«èšãã°ãã°ã«ãŒããŠã§ã¢äžã§çŽæ¥ç®¡çïŒãªã®ã§ãã¿ã€ã ã«ãŒããšããæ¹åŒã¯çµ¶æ» ããŠããã§ãããïŒå®éèªåãçŸåšäœã£ãŠããããªãã®ã¯ãMySQLãµãŒãç«ãŠãŠãã¯ã©ã€ã¢ã³ãåŽã§çŽæ¥åºéå€ãå ¥åããæ¹åŒã ã£ããããŸããG Suiteäžã§æ§ç¯ããå Žåã¯ãããå°çšã®UIãçšæããŠããŸãïŒã
å°å·æ©èœã¯1ã31æ¥ãŸã§ãã¢ããAã¿ã€ãã¯äž¡é¢ã§å°å·ãå¿ èŠãªã®ã§ãè¡šãšè£ã®2åã«åããŠã®å°å·ãå¿ èŠã§ãïŒäžçºã§äž¡é¢å°å·ããã«ã¯ã«ãŒãã®åã¿ãã»ã»ã»ïŒä»¥äžã®æ©èœããããŸãã
- æ¢å®å€ã«ãŠãåæ¥ç¥æ¥ãªã©ãäžæ¬ã§èšå®ããŸããèšå®åŸã¯é£ã®ãã¿ã³ãã¯ãªãã¯ãããšå šå¡ã«é©çšãããŸãã
- åå¥ã§ã¯ãäºåç³è«ã®ããæ絊ãç£äŒãªã©ã®ç»é²ãåå¥ã«å¯èœã«ãªã£ãŠããŸãã
ããããè£ãšè¡šçšã«ãã¿ã³ãããã®ã§ãè¡šãããŸãå šå¡åå°å·ããã®åŸè£ãå šå¡åå°å·ãããããªæãã«ãªããŸãã
å³ïŒã¿ã€ã ã«ãŒãå°å·ããããæéããã£ãŠãåœæ
å³ïŒäŒæ¥äžæ¬èšå®ç»é¢
ã¬ããŒãå°å·æ©èœ
åœæããã®ã¬ããŒããæ¯æææ«ã«å šå¡ã«äžæã«ã¡ãŒã«éä¿¡ããŠããŸããããããéåžžã«å¹æçã§ãæ絊ã®ç³è«ãæªæåºã®ãŸãŸã«ãªã£ãŠã人ããçŸåšã®æ®ãæ絊æ®æ¥æ°ã®åãåããã®äœæžããªã©ç· ããããäžã§ã¯ã¹ã ãŒãºã«æ å ±æäŸãä¿ããã£ããã«ãªããŸãããä»ã§ããããã®æã®ç³è«ç³»ãã¯ãŒã¯ãããŒã·ã¹ãã ã§è¡ãã®ãåžžèãªã®ã§ãçŽã§ã®ç³è«ãšããã®ã¯èŠãªããªããŸããããæ絊ã ãã§ãªãæªæ¯æ¿ã®åæ¥åºå€ãªã©å人ã§èŠããŠããããªãã®ã§ããããã£ãã¢ããã°ãªææ³ãå¹æããããŸããã
çŸåšã¯ãã®äžæ¬éä¿¡æ©èœã¯åæ¢äžã§ãã
å³ïŒãããªæãã§äžèŠ§è¡šç€ºããŠPDFåããŠéã£ãŠãŸãã
Excelã§ç®¡çããå Žåãšã®éã
æ¬ããã°ã©ã ã¯å®ã¯ã»ãšãã©VBAã³ãŒããèšè¿°ããŠããŸããããªãAccessãå©çšããã®ãïŒãã®å©ç¹ããŸãšãããã®ããã®ããã°ã©ã ã«ãªããŸããç¹ã«ã¡ã€ã³ç»é¢ã«è³ã£ãŠã¯æ§ç¯ã«éããŠã¬ãããªã³ãŒããæžãããŠãã®ã¯ãäžéšã®æ€çŽ¢ç»é¢ãããã§ãïŒãããä»ã®ã©ã€ãã©ãªãå©çšããŠããã®ã§ãèªåã§æžããã®ã¯ãããïŒ
- Excelã§ãã®æã®ç®¡çãããå Žåã2次å 管çããã§ããªããããããAccessã¯è€æ°æ¬¡å 管çããã©ãŒã äžã§å¯èœã«ãªãã
- æ¬ããã°ã©ã ã®ã¡ã€ã³ç»é¢ã®ãµããã©ãŒã ã¯èŠªã®ãã©ãŒã ãšè·å¡ã³ãŒãã§é£æºããŠãããããã³ãŒãã¬ã¹ã§å®çŸãå¯èœã
- Excelã®å©ç¹ã¯èªç±ã«çžŠæšªã«è²ã èšè¿°ã§ããç¹ã ããããããã¡ãªããã§ããããå ¥åå¶éãããŠãã¡ããšããŒã¿ã®æŽåæ§ãä¿ãŠãã®ãAccessã®å©ç¹ïŒæ°å€ãã£ãŒã«ãã«å€§æåæ°åå ¥ããããããæ¥ä»ã2019.10.5ãšãå ¥ããããŠãã管çåŽã¯éåžžã«å°ãããšã«ãªãã
- ã¬ã³ãŒãã§ç®¡çãªã®ã§ã管ç察象ãã»ã«ã§ã¯ãªã1è¡åäœãExcelã®å Žåã»ã«åäœã§ã®ç®¡çãæ±ããããã®ã§ãããŒã¿ã®å¥ããŒãã«ãžã®ç§»åãªã©ãæ£ç¢ºãªã³ãŒããèšè¿°ããªããã°ãªããªããããããAccessã¯ã¯ãšãªã§ç°¡åã«ãããå®çŸã§ããïŒè¿œå ã¯ãšãªãåé€ã¯ãšãªïŒ
- ã¬ã³ãŒãã®æŽæ°ïŒäŸãã°æ§å¹ŽåºŠããæ°å¹ŽåºŠãžã®ä»¥éïŒã«éããŠãæ¢åã®ããŒã¿ïŒäŸãã°ã幎äŒæ®æ¥æ°ïŒãªã©ããæŽæ°ã¯ãšãªã«ãŠäžæ¬æŽæ°ããäºãå¯èœã
ã¯ãšãªãå¶ããè ã¯Accessãå¶ãããšèšã£ãŠãéèšã§ã¯ãããŸããããŸããç¹ã«Excelããè±åŽã§ããéå¹çäžã€äžç¢ºå®ã§ãè€æ°ã·ãŒãã«è·šã£ãŠé¢åãªåŠçãããŠã人ã絶ããªãã®ã1.ã®åé¡ç¹ã
Excelã¯æè©®ã·ãŒãåäœãªã®ã§1ç»é¢ã«åºããããŒã¿ã¯çžŠæšªã®2次å ããŒã¿ã§ããããããAccessã¯ãã©ãŒã ã䜿ã£ãŠããã¹ã¿ãŒããŒã¿ïŒè·å¡ãã¹ã¿ãŒïŒã«ä»éãããå¥ã®ããŒãã«ããŒã¿ïŒå€æ ããŒã¿ïŒãªã©ãããµããã©ãŒã ã§åæã«è¡šç€ºå¯èœã§ãå°äžããµããã©ãŒã ã§ã®ããŒã¿å ¥åã¯ãèªåçã«èŠªãã©ãŒã ã®è·å¡IDãå ¥ã£ãŠãããã®ã§èª°ã®å€æ ããŒã¿ãªã®ãæèããäºããªããããŒã¿ã®æŽåæ§ãä¿ã€äºãã§ããïŒèŠªã¬ã³ãŒãã移åããã°ããµããã©ãŒã ãå 容ãå€ããïŒã
ãã®ãµããã©ãŒã ãè€æ°é 眮å¯èœã§ãã¬ããŒãã«ãããŠããµãã¬ããŒãã§ãããå®çŸå¯èœã§ãããã®å©ç¹ããã¡ããšèª¬æããŠããµã€ããäœãã«ãå°ãªãã®ã§ãä»åã¡ãã£ãšèŠæããã£ãã®ã§ã¢ããããŠã¿ãŸããããããããã®å©ç¹ã«ã€ããŠãããã°ã«ãŠè©³çŽ°ã«èª¬æããŠããããšæã£ãŠããŸãã