Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

accessºê²Ù×÷

´ò¿ª    OpenDataAccessPage:ÔÚÒ³ÊÓͼ»òÉè¼ÆÊÓͼÖдò¿ªÊý¾Ý·ÃÎÊÒ³
OpenForm:ÔÚ´°ÌåÊÓͼ¡¢´°ÌåÉè¼ÆÊÓͼ¡¢´òÓ¡Ô¤ÀÀ»òÊý¾Ý±íÊÓͼÖдò¿ª´°Ìå
OpenModule:ÔÚÖ¸¶¨¹ý³ÌµÄÉè¼ÆÊÓͼÖдò¿ªÖ¸¶¨µÄÄ£¿é
OpenQuery:´ò¿ªÑ¡Ôñ²éѯ»ò½»²æ±í²éѯ
OpenReport:ÔÚÉè¼ÆÊÓͼ»ò´òÓ¡Ô¤ÀÀÊÓͼÖдò¿ª±¨±í»òÁ¢¼´´òÓ¡¸Ã±¨±í
OpenTable:ÔÚÊý¾Ý±íÊÓͼ¡¢Éè¼ÆÊÓͼ»ò´òÓ¡Ô¤ÀÀÖдò¿ª±í
²éÕÒ¡¢É¸Ñ¡¼Ç¼ ApplyFilter£º¶Ô±í¡¢´°Ìå»ò±¨±íÓ¦ÓÃɸѡ¡¢²éѯ»òSQLµÄWHERE×Ӿ䣬ÒÔ±ãÏÞÖÆ»òÅÅÐò±íµÄ¼Ç¼£¬ÒÔ¼°´°Ìå»ò±¨±íµÄ»ù´¡±í£¬»ò»ù´¡²éѯÖеļǼ
FindNext£º²éÕÒ·ûºÏ×î½üFindRecord²Ù×÷»ò“²éÕÒ”¶Ô»°¿òÖÐÖ¸¶¨Ìõ¼þµÄÏÂÒ»Ìõ¼Ç¼
FindRecord£ºÔڻµÄÊý¾Ý±í¡¢²éѯÊý¾Ý±í¡¢´°ÌåÊý¾Ý±í»ò´°ÌåÖУ¬²éÕÒ·ûºÏÌõ¼þµÄ¼Ç¼
GoToRecord£ºÔÚ´ò¿ªµÄ±í¡¢´°Ìå»ò²éѯ½á¹û¼¯ÖÐÖ¸¶¨µ±Ç°¼Ç¼
ShowAllRecords£ºÉ¾³ý»î¶¯±í¡¢²éѯ½á¹û¼¯»ò´°ÌåÖÐÒÑÓ¦ÓùýµÄɸѡ
½¹µã GoToControl£º½«½¹µãÒÆ¶¯µ½´ò¿ªµÄ´°Ìå¡¢´°ÌåÊý¾Ý±í¡¢±íÊý¾Ý±í»ò²éѯÊý¾Ý±íÖеÄ×ֶλò¿Ø¼þÉÏ
GoToPage£ºÔڻ´°ÌåÖУ¬½«½¹µãÒÆµ½Ö¸¶¨Ò³µÄµÚÒ»¸ö¿Ø¼þÉÏ
SelectObject£ºÑ¡¶¨Êý¾Ý¿â¶ÔÏó
ÉèÖÃÖµ SendKeys£º½«¼ü·¢Ë͵½¼üÅÌ»º³åÇø
SetValue£ºÎª´°Ìå¡¢´°ÌåÊý¾Ý±í»ò±¨±íÉϵĿؼþ¡¢×Ö¶ÎÉèÖÃÊôÐÔÖµ
¸üРRepaintObjet£ºÍê³ÉÖ¸¶¨µÄÊý¾Ý¿â¶ÔÏóËù¹ÒÆðµÄÆÁÄ»¸üУ¬»ò¶Ô»î¶¯Êý¾Ý¿â¶ÔÏó½øÐÐÆÁÄ»¸üС£ÕâÖÖ¸üаüÀ¨¿Ø¼þµÄÖØÐÂÉè¼ÆºÍÖØÐ»æÖÆ
Requery£ºÍ¨¹ýÖØÐ²éѯ¿Ø¼þµÄÊý¾ÝÔ´£¬À´¸üл¶ÔÏó¿Ø¼þÖеÄÊý¾Ý¡£Èç¹û²»Ö¸¶¨¿Ø¼þ£¬½«¶Ô¶ÔÏó±¾ÉíµÄÊý¾ÝÔ´ÖØÐ²éѯ¡£¸Ã²Ù×÷È·±£»î¶¯¶ÔÏó¼°Æä°üº¬µÄ¿Ø¼þÏÔʾ×îÐÂÊý¾Ý
´òÓ¡ PrintOut£º´òÓ¡»î¶¯µÄÊý¾Ý±í¡¢´°Ìå¡¢±¨±í¡¢Ä£¿éÊý¾Ý·ÃÎÊÒ³ºÍÄ£¿é£¬Ð§¹ûÓëÎļþ²Ëµ¥ÖеĴòÓ¡ÃüÁîÏàËÆ£¬µ«ÊDz»ÏÔʾ´òÓ¡¶Ô»°¿ò
¿ØÖÆ CancelEvent£ºÈ¡ÏûÒýÆð¸ÃºêÖ´ÐеÄʼþ
RunApp£ºÆô¶¯ÁíÒ»¸öWindows»òMS-DOSÓ¦ÓóÌÐò
RunCode£ºµ÷ÓÃVisual Basic Function¹ý³Ì
RunCommand£ºÖ´ÐÐAccess²Ëµ¥À¸¡¢¹¤¾ßÀ¸»ò¿ì½Ý²Ëµ¥ÖеÄÄÚÖÃÃüÁî
RunMacro£ºÖ´ÐÐÒ»¸öºê
RunSQL£ºÖ´ÐÐÖ¸¶¨µÄSQLÓï¾äÒÔÍê³É²Ù×÷²éѯ£¬Ò²¿ÉÒÔÍê³ÉÊý¾Ý¶¨Òå²éѯ
StopAllMacros£ºÖÕÖ¹µ±Ç°ËùÓкêµÄÔËÐÐ
StopMacro£ºÖÕÖ¹µ±Ç°ÕýÔÚÔËÐеĺê
´°¿Ú Maximize£º·Å´ó»î¶¯´°¿Ú£¬Ê¹Æä³äÂúAccessÖ÷´°¿Ú¡£¸Ã²Ù×÷²»ÄÜÓ¦ÓÃÓÚVisual Basic±à¼­Æ÷ÖеĴúÂë´°¿Ú
Minimize£º½«»î¶¯´°¿ÚËõСΪAccessÖ÷´°¿Úµ×²¿µÄС±êÌâÀ¸¡£¸Ã²Ù×÷²»ÄÜÓ¦ÓÃÓÚVis


Ïà¹ØÎĵµ£º

×ªÔØAccess denied for user

×ªÔØµØÖ·£ºhttp://hi.baidu.com/mbaba/blog/item/39dc8b58d41191dc9c8204c8.html
ºÜ¶àÅóÓÑËäÈ»°²×°ºÃÁËmysqlµ«È´²»ÖªÈçºÎʹÓÃËü¡£ÔÚÕâÆªÎÄÕÂÖÐÎÒÃǾʹÓÁ¬½ÓMYSQL¡¢ÐÞ¸ÄÃÜÂë¡¢Ôö¼ÓÓû§µÈ·½ÃæÀ´Ñ§Ï°Ò»Ð©MYSQLµÄ³£ÓÃÃüÁî¡£
Ò»¡¢Á¬½ÓMYSQL¡£
¸ñʽ£º mysql -hÖ÷»úµØÖ· -uÓû§Ãû £­pÓû§ÃÜÂë
1¡¢Àý1£ºÁ¬½Óµ½±¾»úÉϵÄMYSQL¡ ......

phpÁ¬½ÓaccessµÄÀà

<?php
/*
 * Created on 2008-10-25
 *
 * developer by Alex.do QQ:20779512
 * PHP 5.0
 */
 class mdbClass {
    var $dbPath = 'database/#123123#.mdb';    //Êý¾Ý¿â·¾¶
    var $tabName;     & ......

C# ²Ù×÷ACCESSÊý¾Ý¿â

Ô­ÎÄ£ºhttp://www.cnblogs.com/whitetiger/archive/2007/03/27/689620.html
 ÔÚBETA2ÖУ¬¡£NETÌṩÁËÒÔϵÄNAMESPACE£º
System.Data Namespace
System.Data.OleDb £¨ºÍBETA1ÖÐÒѾ­²»Í¬ÁË£¬ËùÒÔÈç¹ûÄÃBETA1ÖеijÌÐòµ½BETA2ÖÐÀ´ÔËÐп϶¨²»¿ÉÒԵģ©
Èç¹ûÏë½²Çå³þÕâЩ¶«Î÷£¬ÎÒ²»ÈÏΪÊÇÎÒ¿ÉÒÔ×÷µ½µÄ£¬ËùÒÔÎÒÏëͨ¹ýһЩ¾ ......

dzÒé·ÇAccessÊý¾Ý¿âÔÚVBÖеıà³Ì¼°Ó¦ÓÃ

Visual BasicÓÐ×ÅÇ¿´óµÄÊý¾Ý¿â´æÈ¡ÄÜÁ¦£¬²»½öÄܹ»Ö±½ÓÖ§³ÖMs AccessÊý¾Ý¿â£¬¶øÇÒͨ¹ýÆäÄÚ²¿°²×°µÄISAMÇý¶¯³ÌÐòʹËüÄܼä½ÓÖ§³ÖFoxPro¡¢dBASEµÈÍâÀ´Êý¾Ý¿â¡£±¾ÎIJ»½ö´ÓVBÊý¾Ý¿âÌåϵ½á¹¹µÄ½Ç¶È̽Ë÷ÁËVB¶ÔÕâЩÍâÀ´Êý¾Ý¿âµÄÖ§³Ö£¬»¹½áºÏÁËһЩʵÀý¾ßÌå²ûÊöÁËʹÓÃÊý¾Ý¿â´æÈ¡¶ÔÏó±äÁ¿µÄ·½·¨ÊµÏÖÕâЩÍâÀ´Êý¾Ý¿âµÄн¨¡¢¿â½á¹¹Ð޸ġ¢ ......

AccessʹÓòÎÊý»¯UPDATEÊý¾Ýʱ£¬Êý¾ÝÎÞ·¨¸üеÄÎÊÌâ

      ½ñÌìupdate accessÊý¾Ý¿âʱ£¬Ê¹ÓÃÁ˲ÎÊý»¯µÄ·½Ê½£¬½á¹û²»±¨´í£¬µ«ÊÇÊý¾ÝҲûÓиüС£¾­¹ýgoogle·¢ÏÖaccessʹÓòÎÊý»¯Ê±£¬²ÎÊýλÖñØÐëºÍ¸³ÖµË³ÐòÏàͬ²ÅÐУ¬·ñÔò¸üÐÂʱ¾Í»á³öÏÖÊý¾ÝÎÞ·¨¸üе«ÊÇÒ²²»±¨´íµÄ¹ÖÏÖÏó¡£
      ÀýÈç:update tablename set [a]=@a,[b]=@b ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ