Á¬accessÊý¾Ý¿âÁ¬²»ÉÏÊÇÔõô»ØÊ - Web ¿ª·¢ / ASP
VBScript code: <% Response.Buffer = True Response.ExpiresAbsolute = Now() - 1 Response.Expires = 0 Response.CacheControl = "no-cache" Response.AddHeader "Pragma", "No-Cache" On Error Resume Next dim conn dim connstr dim db db="../Data/info.mdb" Set conn = Server.CreateObject("ADODB.Connection") connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db) conn.Open connstr If conn.Errors.count>0 Then Response.Write "<script language='javascript'>alert('Êý¾Ý¿âÁ¬½Ó³ö´í,ÇëÁªÏµÏµÍ³¹ÜÀíÔ±!');window.location='';</script>" Else 'Response.Write "Êý¾Ý¿âÁ¬½Ó³É¹¦£¡" End If %> ´úÂëÊÇÕâÑùµÄ£¬±£Ö¤Â·¾¶ÊǶԵ쬶øÇÒÎÒÕâÑùÁ¬ÆäËüµÄaccessÊý¾Ý¿âÒ²ÄÜÁ¬ÉÏ£¬¾ÍÊÇÎÒÏÖÔÚÒªÁ¬µÄÕâ¸öÁ¬²»ÉÏ£¬ºÜÓôÃÆ£¡£¡£¡£¡
°ÑÕâ¾äÈ¥µôOn Error Resume Next£¬ÈÃÒ³ÃæÏÔʾһÏ´íÎóÄÚÈÝ »¹ÓУ¬ÄãÓõķþÎñÆ÷ÊÇʲô£¿iis6¼°ÒÔºóĬÈÏÊDz»ÔÊÐí·ÃÎÊ../ÕâÑùµÄÄÚÈݵģ¬ÐèÒªÅäÖòſÉÒÔ iis7 ÎÒ¿ªÆôÁ˸¸Â·¾¶£¬»¹ÊDz»ÐÐ °´ÎÒһ¥˵µÄ£¬ÏȰѴíÎóÏÔʾ³öÀ´ db="../Data/info.mdb" ·¾¶ÎÊÌâÒýÓà °ÑÕâ¾äÈ¥µôOn Error Resume Next£¬ÈÃÒ³ÃæÏÔʾһÏ´íÎóÄÚÈÝ Ö§³Ö´íÎó²Å»áÖªµÀÔÒò£¡ {
Ïà¹ØÎÊ´ð£º
ÎÒ½«Ò»¶Î4000À´×ÖµÄÎı¾¸³Öµ¸øËüÔõô¾Í³ö´íÁË,ÌáʾÔËÐÐʱ´íÎó2176 Õâ¸öÊôÐÔµÄÉèÖÃֵ̫³¤? ÄãÊÇÔõÑù¸³ÖµµÄ£¿ ²âÊÔÁËһϣ¬Óñ¸×¢×ֶθøÎı¾¿ò×öÊý¾ÝÔ´£¬Ã»ÓÐÌáʾÉèÖÃֵ̫³¤,14893×Ö·û ÒýÓÃÎÒ½«Ò»¶Î4000À´×ÖµÄÎ ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´... ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
ÎÊÌâÊÇÕâÑùµÄ,ÏÖÔÚÓÐÒ»¸ö¹¤×ʱí,ÊÇEXCELµÄ,ÎÒÒª°ÑËüµ¼ÈëACCESS,ÒòΪ Òª²éѯÿ¸öÈ˵Ť×Ê,¸ù¾Ý²»Í¬µÄ±àºÅ¿ÉÒÔ²éѯµ½Ïà¶ÔµÄÈË, ÓÃASP Ôõô½«EXCELµ¼Èëµ½ACCESS,¶øÇÒÿÔ¶¼Óв»Í¬µÄ±í, ÒýÓà Æäʵ¾ÍÊǰÑEXCELµ±³ÉÊý ......
ÎÒ×öÁËÒ»¸öС³ÌÐò£¬ÏëʵÏֵŦÄܾÍÊÇÔÚÎı¾¿òÖÐÊäÈëÐÕÃû£¬µã»÷²éѯ°´Å¥£¬¾ÍÄܲ鵽ACCESSÊý¾Ý¿âÖдËѧÉúµÄÐÅÏ¢£¨±àºÅ£¬ÐÕÃû£¬ÐÔ±ð£¬ÄêÁ䣩¿ÉÎÒ²»ÖªµÀÓï·¨¸ñʽ£¬ÎÒ×Ô¼ºÐ´µÄÓï¾äµ÷ÊÔÄÜͨ¹ý£¬¿ÉÊÇÔËÐÐʱ³ö´í£¨µã»÷²éѯ°´ ......
¸Õ¸Õ½Ó´¥VB.NET£¬¶Ô.NET»ù±¾Ê²Ã´Ò²²»¶®£¬Çë¸ßÊÖ¸øÒ»¶Î½ÏÍêÕû´´½¨accessÊý¾Ý¿âµÄʾÀý´úÂ룬ÈÃÎÒѧϰһÏ¡£ Ëùν½ÏÍêÕû´´½¨Êý¾Ý¿âʱ¶¨Òå¸÷¸ö×Ö¶ÎÀàÐ͵ıíʾ·½·¨£¬ÈçÕûÊýÐÍ£¬¸¡µãÐÍ£¬×Ö·ûÐÍ£¨¶¨Ò峤¶ÈÈçºÎ±íʾ£©¡£Ð»Ð» ......