ÇóACCESSÊý¾Ý¿â
ÄÄλ´ó¸çÓÐACCESSÊý¾Ý¿â °¡£¿
¸øÐ¡µÜÒ»¸ö£¡
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°OFFICEʱѡÔñ°²×°ACCESS
°²×°°ì¹«Èí¼þ£¬Ñ¡Ôñ×Ô¶¨Òå°²×°£¬È»ºóÑ¡ÉÏACCESS¾Í¿ÉÒÔÁË
officeÍêÕû°æ¾ÍÓУ¬°²×°µÄʱºòÑ¡×Ô¶¨Òå°²×°
ÄãÔÚÏÂÔØ¸ö´øaccessÊý¾Ý¿âµÄoffice
°²×°OFFICE 2000/2003/2007 ¶¼¿ÉÒԵġ£
°²×°ÍêÈ«°æµÄofficeÓÃ΢ÈíµÄ
Èç¹ûÄãÒªÊǰ²×°Á˽ðɽµÄwps office2007ÀïÃæÊDz»»áÓÐaccessµÄ
ÓеãÃÔºý
Office°ì¹«Èí¼þ×Ô´øµÄ¾ÍÓа¡ Ò»°ãװϵͳʱûÓдø£¬µ«Äã¿ÉÒÔ×Ô¼ºÈ¥ÍøÉÏÏÂÔØÒ»¸ö£¬È»ºó×°µÄʱºòÑ¡Ôñ°²×°¾Í¿ÉÒÔÁË£¬ÎÒÓõÄÊÇ office2007ËĺÏÒ»¾«¼ò°æ
ÏÂÍêÕû°æµÄoffice2003
..............
.
Óе¥¸öµÄACCESS£¬Ä㵽ѸÀ×È¥£¬»òÕßwww.bibidu.comËÑË÷һϾͿÉÒÔÕÒµ½
Ïà¹ØÎÊ´ð£º
ÎÒµÄÏîÄ¿µÄ¼¸¸öÖØÒªµÄ±í·ÅÔÚÕâ¸öAccessÀï¡£Õ⼸¸ö±íÖ»¶ÁµÄ²»ÐèÒªÐ޸ġ£ÇëÎÊÓÐʲô·½·¨½ûÖ¹·¢ÉúÐÞ¸ÄÄØ£¿ÎÒÒª±£Ö¤Êý¾ÝµÄÍêÕûÐÔ¡£
2003 ÖпÉÒÔ½øÐÐÓû§×éµÄȨÏÞµÄÉèÖá£
ÎÒÖ»ÏëÒª2007µÄ¡£ÒòΪÃÜÂ뻹ûÓÐÈËÄÜÆÆ½â³ö ......
ÎÒÓÃAccessµÄʱºò£¬IDÊÇÖ÷¼ü×Ô¶¯Éú³É¡£
ÄDzåÈëÒ»Ìõ¼Ç¼µÄʱºò£¬ÔÚÖ´ÐÐÁ˲åÈëÓï¾äÖ®ºó»¹ÓÐÒ»¸ö´úÂëstring sqlGetId = "select max(Nid) from News" ;
ÊÇÏë»ñÈ¡¸Õ²Å²åÈëµÄ¼Ç¼ËùÉú³ÉµÄID£¬¿ÉÊÇÿ´Î»ñÈ ......
VB+Access×öµÄϵ統£¬
為·½±ã²é閱與´òÓ¡£¬
Ðè導³ö為execl±í¸ñ£¬
help¡£
環¾³£ºAccess±íÊÇAccess 2000£»
ÍøÉϺܶà,°Ù¶ÈÒ»ÏÂ
¹Ø×¢£¡
´°Ìå´úÂë
VB ......
±¾ÈËÔÚ±àдһ¸öСÐÍÍøÕ¾£¬Êý¾Ý¿âÊÇAccessµÄ£¬ÆäÖÐÓÐÒ»¸ö±íÃûΪ:user,×Ö¶ÎΪÈçÏÂ:
USERID(Ö÷¼ü£¬×Ô¶¯±àºÅ),
ID(Îı¾),
password£¨Îı¾£©,
txtEmail(Îı¾)
Àý£ºÖ´ÐÐÒÔÏÂupdateÓï¾ä£¬ÌáʾÎÞ·¨¸ü ......
SELECT *
from OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',
'Data Source="C:\Documents and Settings\**\My Documents\cc.mdb";User ID=Admin;Password=')...a
ÎÒÖ»ÖªµÀ ......