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

VCÐÞ¸ÄAccessÃÜÂë

void ModifyDBCode()
{
 CString strPath;
 ::GetModuleFileName(GetModuleHandle(NULL),strPath.GetBuffer(256),256);
 strPath.ReleaseBuffer();
 int flag=strPath.ReverseFind('\\');
 int size=strPath.GetLength();
 strPath.Delete(flag,size-flag);
 strPath= strPath+ _T("\\test.mdb");     //Êý¾Ý¿âÃû³Æ
 CString strConn=_T("Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=");
 CString buf=strPath;
 ASSERT(buf != _T(""));
 strConn+=buf;
 strConn+=_T(";Jet OLEDB:Database Password = ");
 strConn+= g_strPassword;
 strConn+=_T(";Mode=Share Deny Read|Share Deny Write");      // du zhan fang shi da kai
 CADODatabase pAdoDb;
 pAdoDb.SetConnectionString(strConn);
 if(!pAdoDb.Open()) return;
 CString strExe = _T("ALTER DATABASE PASSWORD [");
 strExe += m_strNewCode;
 strExe += _T("] [");
 strExe += g_strPassword;
 strExe += _T("]");
 pAdoDb.Execute(strExe);
}


Ïà¹ØÎĵµ£º

MFC ´úÂëÅäÖÃACCESSµÄODBCÁ¬½Ó

 SQLConfigDataSource
´´½¨ODBCÊý¾ÝÔ´¿ÉÒÔµ÷ÓÃWindowsϵͳ×ÓÄ¿
¼ÏµĶ¯Ì¬Á´½Ó¿âOdbcint.dllÖеĺ¯ÊýSQLConfigDataSource()
¸Ãº¯Êý¿ÉÒÔ¶¯Ì¬µØÔö¼Ó¡¢Ð޸ĺÍɾ³ý
Êý¾ÝÔ´¡£
SQLConfigDataSource()º¯Êý
SQLConfigDataSource()µÄÔ­ÐÍÈçÏÂ:
BOOL SQLConfigDataSource(HWND hwndParent, UINT
fRequest ......

¹ØÓÚACCESSÖÐÖØ¸´ÐеĴ¦Àí

ACCESSÖÐÖØ¸´ÐеĴ¦Àí
ACCESSÖУ¬Ê¹ÓÃdistinctºÍgroup byºó£¬Èç¹ûÔÚjavaÖÐʹÓÃrs.next()µÄ»°£¬¾Í»áÌáʾ“ÎÞЧµÄÓαꔴíÎó¡£
µ«ÊÇ£¬²¢·Ç²»Ö§³ÖÉÏÃæÁ½¸öÓï·¨¡£
ËùÒÔ£¬¿ÉÒÔͨ¹ýÒÔÏÂÓï·¨½øÐжþ´Î²éѯ£¬½«Öظ´Êý¾ÝÈ¥µô¡£
select stockName from (select stockName from stock group by stockName) order by stock ......

AccessÓëSql ServerÖ®ASP´úÂë±È½Ï

ºǫ́Êý¾Ý¿â£º
[Microsoft Access]
Óë
[Microsoft Sql Server]
¸ü»»Ö®ºó£¬ASP´úÂëӦעÒâÒªÐ޸ĵÄһЩµØ·½£º
[Ò»]Á¬½ÓÎÊÌ⣨¾ÙÀý)
[Microsoft Access]
constr = "DBQ=c:\data\clwz.mdb; DRIVER={Microsoft Access Driver (*.mdb)}"
[Microsoft Sql Server]
constr = "DRIVER={SQL Server};SERVER=host;DATA ......

POJ Access denied ½â¾ö°ì·¨

ÉÏÍøgoogleÁËһϣ¬¿´Á˼¸¸öÈ˵ÄÌû×Ó£¬´ó¸ÅÃ÷°×ÁËÊÇʲôÒâ˼¡£
     Èç¹ûÒ»¸öÓû§µÄIPÔÚ×î½üÒ»¶Îʱ¼äÄÚ¶à´ÎÓÉÓÚÃÜÂë´íÎóµÇ¼ʧ°Ü£¬ÄÇôϵͳ¾Í»á°ÑÕâ¸öÓû§·âµô£¬submit»òÕßmail¾Í»áÌáʾAccess denied.
     Õâ±¾ÊÇÒ»¸ö°²È«´ëÊ©£¬µ«ÊÇûÏëµ½poj¿ªÍ¨ËùνµÄ"¹«Íø¼ÓËÙ"Ö®º ......

Access 2007µÄʹÓ÷½·¨

  ±¾À´¿¼ÂÇÓÃXMLÎļþÀ´´æÊý¾ÝÊÇÒòΪÆä¿çƽ̨ÐÔ£¬¶øÇÒ²»Óð²×°Ìض¨µÄÈí¼þ¡£µ«¾­¹ýÑо¿ÁËÒ»Õó×Ó·¢ÏÖ£¬XMLÓÃÓÚ´æ·ÅÉÙÊý¾ÝÊÇ¿ÉÒÔ£¬µ«´æ·Å´óÖÐÐÍÊý¾Ý¾ÍÏԵúܳÔÁ¦£¬»³ÒÉҲûÓÐÈË»áÕâô×ö¡£¶øÈç¹û²ÉÓÃSQL SERVER´æÊý¾Ý£¬ÓÖÏԵñȽÏÇü²Å£¬±Ï¾¹ÎÒ×öµÄÖ»ÊÇÑо¿¿Í»§¶ËµÄÒ»¸öС³ÌÐò£¬ÅäÖôú¼ÛҲ̫´óÁË¡£»ùÓÚÕâÁ½ÕßÖ®¼ä£¬»¹ÊǾö¶¨Ñ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ