µÃµ½access±í×Ö¶ÎÃûVBS½Å±¾
set adoCN =createobject("ADODB.CONNECTION")
set strCnn =createobject("ADODB.Recordset")
set rstSchema =createobject("ADODB.Recordset")
Dim I
dim n
str1 = "DBQ=E:\data1.MDB;DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};"
adoCN.Open str1
rstSchema.open "select * from table1",adoCN,1,1
n = rstSchema.Fields.Count - 1
for i =0 to n
out = out & vbCr & rstSchema.Fields(i).Name
next
rstSchema.Close
adoCN.Close
MsgBox out
Ïà¹ØÎĵµ£º
×î½üÔÚ×öAccessµÄÒ»¸öÏîÄ¿£¬×ÜÊÇĪÃûÆäÃîµÄÌáʾ£º“Insert Into Óï·¨´íÎ󔣬ÕâÑùµÄÐÅÏ¢×ܸøÈË´øÀ´ºÜ¶àÂé·³£¬ÓÐʱºòΪÁËÕâÑùÒ»¸ö´íÎóÒªÕҺþòÅÄܽâ¾öÎÊÌ⣬"Insert Into Óï·¨´íÎó"Õâ¸öÌáʾ±¾Éí°üº¬µÄÐÅÏ¢Á¿ºÜÉÙ£¬ÔÚ¸ú×Ù¶ÑÕ»ÖÐÓÐÕÒ²»µ½¸üÏêϸµÄÐÅÏ¢£¬ÎªÁ˱ÜÃâ´ó¼ÒÔÚ¿ª·¢µÄ¹ý³ÌÖÐÓöµ½Í¬ÑùµÄ´íÎóºÍÀ§ÈÅ¡£Í¨¹ý²éÕÒºÍ ......
½ñÌìÔÚLinuxÏÂÓÃeclipse 3.5¿ª·¢JpcapÏà¹ØµÄ³ÌÐò£¬ÏÈÊÔÊÔ¹Ù·½µÄUdpSend.javaÄÜ·ñÅÜÆðÀ´¡£結¹ûeclipse¸ø³öÁËÈçÏ´íÎóÌáʾ£º
Access restriction: The type JpcapCaptor is not accessible due to restriction on required library /media/sda7/opt/jdk1.6.0_16/jre/lib/
ext/jpcap.jar
ÆäʵҪ½â¾öËüÒ²º ......
ÊÀʶ´Ã÷½ÔѧÎÊ£¬ÈËÇéÁ·´ï¼´ÎÄÕ¡£×öASPʱ£¬×î³£ÓõÄÊý¾Ý¿â¼´SqlserverÓëAccessÊý¾Ý¿âĪÊôÁË£¡
µ«Ê¹Óûᾳ£·¢ÏֺܶàSQLÖ´ÐеÄÎÊÌâ¡£ÕâÀïÕûÀí³öÖ®¼äµÄ²îÒ죬×ö¸öÊ®´ó²îÒìµÄ×ܽᡣ
ACCESS½á¹¹¼òµ¥ÈÝÒ×´¦Àí£¬¶øÇÒÒ²ÄÜÂú×ã¶àÊýµÄÍøÕ¾³ÌÐòÒªÇó£¬Ò²ÊdzõѧÕßµÄÊÔÅ£µ¶¡£
ACCESSÊÇСÐÍÊý¾Ý¿â£¬¼ÈÈ»ÊÇСÐ;ÍÓÐËû¸ù±¾µÄ¾ÖÏÞÐÔ£º
......
½ñÌìÔÚÐÞ¸ÄÒÔÇ°¿ª·¢µÄÒ»¸öÍøÕ¾µÄʱºòÓöµ½Ò»¸öÎÊÌ⣬ÒòΪ¹¦ÄܵÄÐèÒª£¬ÒÔÇ°µÄÒ»¸öÊý×ÖÀàÐÍ×ֶθıäΪÎı¾×ֶΣ¬ÒòΪÕâ¸ö×Ö¶ÎÐèÒª°üº¬¶à¸öÀà±ðµÄID£¬ÒÔÇ°Õâ¸ö×Ö¶ÎÖ»¶ÔÓ¦Ò»¸öIDµÄ¡£
ÍøÕ¾ÊÇASP VBÓïÑԵģ¬Êý¾Ý¿âʹÓõÄÊÇAccess
ÐÞ¸ÄÊý¾ÝÀàÐÍÖ®ºóǰ̨µÄ²éѯ´úÂë¾Í²»ÄÜʹÓÃÖîÈçxID=1ÕâÖÖÌõ¼þÁË¡£ÓÉÓÚÏÖÔÚ¸Ã×ֶαäΪÎı¾ÀàÐ ......