Access×Ô¶¯±àºÅ×Ö¶ÎÖØмÆÊýÎÊÌâ
ÔÚÉè¼ÆaccessÊý¾Ý¿âʱ£¬±íÖÐ×Ö¶ÎÊôÐÔÓÐidÏîÉèΪ×Ô¶¯±àºÅÀàÐ͵ģ¬Ìí¼ÓÐí¶à¼Ç¼ºó£¬ÔڸñíÖн«ËùÓмǼɾ³ý£¬ÔÙÐÂÔö¼Ç¼²¢²»»á´Ó1¿ªÊ¼,ÈçºÎ²Ù×÷¿ÉÒÔʹÐÂÔö¼Ç¼±àºÅÖØдÓ1¼ÆÊý£¿
½â¾ö·½·¨£ºÉ¾³ý±íÀïËùÓÐÊý¾Ý È»ºóѹËõÐÞ¸´Êý¾Ý¿â ÔÙÐÂÔö¾Í´Ó1±àºÅÁË
×¢:
2000-2003ѹËõÐÞ¸´Êý¾Ý¿âµã»÷:¹¤¾ß→Êý¾Ý¿âʵÓù¤¾ß→ѹËõºÍÐÞ¸´Êý¾Ý¿â
2007ѹËõÐÞ¸´Êý¾Ý¿âµã»÷:Office°´Å¥→¹ÜÀí→¹ÜÀí´ËÊý¾Ý¿â→ѹËõºÍÐÞ¸´Êý¾Ý¿â
(´Ë·½·¨²¢Ã»ÓжàÉÙʵ¼ÊÓ¦ÓüÛÖµ,ÊʺÏҪ׷ÇóÍêÃÀµÄ°®ºÃÕßÅóÓÑÓÃ)
Ïà¹ØÎĵµ£º
HTML clipboard
Revealing the revolutionary fingerprint access clocking in/out system for
businesses. No more cards, no more paperwork, no more hassle! This digital
fingerprint access terminal and data logger registers finger prints for time
management plus also works as an authorized pe ......
set adoCN =createobject("ADODB.CONNECTION")
set strCnn =createobject("ADODB.Recordset")
set rstSchema =createobject("ADODB.Recordset")
Dim I
dim n
str1 ......
1.Á¬½ÓÊý¾Ý¿âConnDB()Àà
package tool;
/****************************
**
**ÊôÐÔÎļþÓëÊý¾Ý¿â¾ùÔÚtool°üÏÂÃæ
**
*****************************/
/* Êý¾Ý·ÃÎÊ×é¼þ */
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
impor ......
½Ó 2
·½·¨3 :
ÕâÖÖ·½·¨Ò²ÐèÒªÓû§×Ô¼º´´½¨Ò»¸öÊý¾ÝÔ´£¬µ«ÊÇ£¬ËùÐèÒª½øÐеIJ½Ö裬±È·½·¨2ÒªÉÙÉÏÐí¶à¡£
´´½¨ºÃÓû§±í¡£
´´½¨Êý¾ÝÔ´£¨¿ØÖÆÃæ°å->Êý¾Ý¹ÜÀí->Êý¾ÝÔ´ Ë«»÷ -> Ñ¡Ôñ Îļþ DSN -> Ìí¼Ó -> Microsoft Access Driver -> ÊÖ¶¯ÊäÈëDSN ±£´æµÄλÖü°Ãû³Æ -> Ñ¡Ôñ(S) ²¢Ñ¡ ......
ÊìϤSQL SERVER 2000µÄÊý¾Ý¿â¹ÜÀíÔ±¶¼ÖªµÀ£¬ÆäDTS¿ÉÒÔ½øÐÐÊý¾ÝµÄµ¼Èëµ¼³ö£¬Æäʵ£¬ÎÒÃÇÒ²¿ÉÒÔʹÓÃTransact-SQLÓï¾ä½øÐе¼Èëµ¼³ö²Ù×÷¡£ÔÚTransact-SQLÓï¾äÖУ¬ÎÒÃÇÖ÷ҪʹÓÃOpenDataSourceº¯Êý¡¢OPENROWSET º¯Êý£¬¹ØÓÚº¯ÊýµÄÏêϸ˵Ã÷£¬Çë²Î¿¼SQLÁª»ú°ïÖú¡£ÀûÓÃÏÂÊö·½·¨£¬¿ÉÒÔÊ®·ÖÈÝÒ×µØʵÏÖSQL SERVER¡¢ACCESS¡¢EXCELÊý¾Ýת»»£ ......