AccessÊý¾Ý¿â±»¹ÒÂí£¬´ò²»¿ªÁË
ÍøÕ¾ÀïµÄaccessÊý¾Ý¿âÎÒÓõÄÊÇaspºó׺£¬ÏÖÔÚÍøÕ¾´ò²»¿ªÁË£¬Êý¾Ý¿âÎļþÎÒÏÂÔØÏÂÀ´¸Ä»Ømdbºó׺ÓÃaccessÒ²´ò²»¿ªÁË£¬ÐÞ¸´Ò²Ã»Óá£Ìáʾ¡°²»¿Éʶ±ðµÄÊý¾Ý¿â¸ñʽ¡±£¬¹À¼ÆÊÇÊý¾Ý¿â±»¹ÒÂíÁ˰ɣ¬ÏÖÔÚ»¹Óа취»Ö¸´Âð¡£Í´¿à°¡£¬Ã»Óм°Ê±±¸·Ý¡£
²»»á°É£¬Õâô²Ò¡£¡£¡£¡£¡£¡£¡£
ÓÃMDB¾ÍÊÇÒª¾³£±¸·Ý
MDBûÓÐÈÕÖ¾£¬³ö´íÈçûÓб¸·ÝµÄ»°£¬³ýÁËÕÒרҵ¹«Ë¾ÐÞ¸´Í⣬»ù±¾Ã»ÓÐÆäËü·½·¨
ÎÒÊÔ¹ýÓÃUltraEdit´ò¿ª£¬µ«ÍêÈ«¿´²»¶®£¬²»¸Ò¶¯ÊÖ¡£¡£
¿ÉÅ£¡
ÔÙµÈÒ»Ìì°É£¬Ã»°ì·¨¾Í½áÌùÁË¡£¡£
¹ÒµÄÂíÖªµÀʲô´úÂëÂð£¿
ÓÃÎı¾Ìæ»»Æ÷£¬½«ÆäÌæ»»ÁË¡£
End_rbody_60449164//-->
¸Ã»Ø¸´ÓÚ2009-10-16 09:05:12±»°æÖ÷ɾ³ý
¶ÔÎÒÓÐÓÃ[0]
¶ª¸ö°åש[0]
ÒýÓÃ
¾Ù±¨
¹ÜÀí
TOP
nianzhang747
(ì«·ç)
µÈ¡¡¼¶£º
#12Â¥ µÃ·Ö£º10»Ø¸´ÓÚ£º2009-10-16 08:34:18
¹ÒÁË »¹Ã»ÈÕÖ¾£¿
Ïà¹ØÎÊ´ð£º
ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......
_RecordsetPtr CMyAdo::SelectRecord(string &where, string &tablename,string &field, int way )
{
int ret = 0;
_RecordsetPtr pset;
CString sql;
& ......
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕ ......
½öÊÇÒ»¶Î¸üÐÂÃÜÂëµÄ´úÂëÈçÏ¡£±¨´íÐÅϢΪ£º
δ´¦ÀíµÄ¡°System.Data.OleDb.OleDbException¡±ÀàÐ͵ÄÒì³£³öÏÖÔÚ System.Data.dll ÖС£
ÆäËûÐÅÏ¢: UPDATE Óï¾äµÄÓï·¨´íÎó¡£
µ¥¶ÀµÄINSERTÓïÑÔÔÚÊ ......
¿É·ñ½«accessÊý¾Ý¿âÍêÈ«µ¼Èësqlserver
µ±È»¿ÉÒÔ
Óõ¼Èëµ¼³ö¹¤¾ßÀ´×ö
ͬÒâÂ¥ÉÏ¡£
SQL code:
/*************µ¼ÈëAccess********************/
insert into B±í selet * from openrowset('Microsoft.Jet ......