ããAccessæ¯ç±å¾®è½¯åå¸çå ³èå¼æ°æ®åºç®¡çç³»ç»ãå®ç»åäºâMicrosoft Jet Database Engineâåâå¾å½¢ç¨æ·çé¢â两项ç¹ç¹ï¼æ¯Microsoft Officeçæåä¹ä¸ã
ããä¼ç¹ï¼Accessé¨ç½²ç®åæ¹ä¾¿ï¼è¿ç¨èµ·æ¥é常çµæ´»ã主è¦æ¯æ¡é¢æ°æ®åºç³»ç»ï¼å®ä¹å¯ä»¥å¼ååºäºèªå·±çæ¡é¢æ°æ®åºåºç¨(UI)ï¼å¹¶å¯ä»¥ä½ä¸ºå端å¼åå·¥å ·ä¸å ¶å®æ°æ®åºæé å¼ååºç¨ç¨åº(å¦SQL ServerãDB2ãOracleç)ï¼çç»ç软件设计å¸åèµæåæå¸å©ç¨å®æ¥å¼ååºç¨è½¯ä»¶ï¼èä¸äºä¸çç»çç¨åºååéç¨åºåçå级ç¨æ·å使ç¨å®æ¥å¼åç®åçåºç¨è½¯ä»¶ã
ãã缺ç¹ï¼æ°æ®å¨åéå°å®å ¨æ§ä¸å¤é«ï¼å äºç¨æ·çº§å¯ç 容æç ´è§£ãC/Sç»æä¸å¯¹æå¡å¨è¦æ±å¾é«ï¼å¦å容æé æMDBæåï¼å¹¶åæ°255ï¼ä½æ¯å¯¹é«å¼ºåº¦æä½éåºæ§å·®ï¼å¦ææå¡å¨ä¸å¤å¥½ãç½ç»ä¸å¤å¥½ãç¼ç¨æ¹æ³ä¸å¤å¥½ï¼6-7个人åæ¶è®¿é®å°±è½å¯¼è´MDBæåæè 并æ»ï¼ä¸è½å°VBA代ç å¼åç软件系ç»ç´æ¥ç¼è¯æExeå¯æ§è¡æ件ï¼ä¸è½è±ç¦»Accessæè Access Runtimeç¯å¢ï¼è¯¥ç¯å¢ç¸å¯¹å ¶ä»è½¯ä»¶ä½ç§¯è¾å¤§ï¼50Må·¦å³ï¼ãMicrosoft Accessæ°æ®åºæä¸å®çæéï¼å¦ææ°æ®è¾¾å°100Må·¦å³ï¼å¾å®¹æé ææå¡å¨IISåæ»ï¼æè æ¶èææå¡å¨çå å导è´æå¡å¨å´©æºã
ããSQL Serveræ¯ä¸ä¸ªå ³ç³»æ°æ®åºç®¡çç³»ç»ã
ããä¼ç¹ï¼å®å ¨æ§é«çæ£ç客æ·æº/æå¡å¨ä½ç³»ç»æï¼å¾å½¢åç¨æ·çé¢ï¼ä½¿ç³»ç»ç®¡çåæ°æ®åºç®¡çæ´å ç´è§ãç®åï¼ä¸°å¯çç¼ç¨æ¥å£å·¥å ·ä¸ºç¨æ·è¿è¡ç¨åºè®¾è®¡æä¾äºæ´å¤§çéæ©ä½å°ãSQL Serverä¸Windows NTå®å ¨éæï¼å©ç¨äºNTç许å¤åè½ï¼å¦åéåæ¥åæ¶æ¯ï¼ç®¡çç»å½å®å ¨æ§çãSQL Serverä¹å¯ä»¥å¾å¥½å°ä¸Microsoft BackOffice产åéæãå ·æå¾å¥½ç伸缩æ§ï¼å¯è·¨è¶å¤ç§å¹³å°ä½¿ç¨ï¼å¯¹Webææ¯çæ¯æï¼ä½¿ç¨æ·è½å¤å¾å®¹æå°å°æ°æ®åºä¸çæ°æ®åå¸å°Web页é¢ä¸ãSQL Serverè¿æä¾æ°æ®ä»åºåè½ï¼è¿ä¸ªåè½åªå¨Oracleåå ¶ä»æ´æè´µçDBMSä¸ææã
ãã缺ç¹ï¼å åè½å¼ºå¤§ï¼æ以æä½æ°æ®æ¯Accessè¾ä¸ºå¤æã