accessÖÐɾ³ýÎÊÌ⣬ºÜÀ§ÈÅ£¬´ó¼ÒÀ´°ï°ïÎÒ°É
¹Ø¼ü´úÂëÈçÏÂ:
ijÎļþÖж¨ÒåÒ»¸ö²Ù×÷¶ÔÏó£º
CAccessDB m_DBOperation;
²¢ÔÚij´¦µ÷Óãº
m_DBOperation.Init(sFilename, sPassword);
m_DBOperation.UnInit();
void CAccessDB::Init(CString sFileName, CString sPassword)
{
......
......
CString strConnect("");
CString strRead("");
strConnect.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s;Jet OLEDB:Database Password=%s", sFileName, sPassward);
strRead.Format("Delete from DAY_NOTE where ID=1 or ID=2");
bstr_t bstrConnet = strConnect.AllocSysString();
bstr_t bstrRead = strRead.AllocSysString();
try
{
m_csOperation.Lock();
m_pConnection.CreateInstance(__uuidof(Connection));
m_pConnection->Open(bstrConnet, "", "", -1);
m_pRecordSet.CreateInstance(__uuidof(Recordset));
m_pRecordSet->Open(bstrRead, m_pConnection.GetInterfacePtr(), adOpenDynamic, adLockOptimistic, adCmdText);
m_csOperation.Unlock();
}
catch(_com_error e)
{
m_csOperation.
Ïà¹ØÎÊ´ð£º
ÎÒĿǰ±íµÄÅÅÁÐÊÇÉÏÃæÕâÕÅͼÕâÇé¿ö£º
ÎÒÏ£Íûµ÷Õû³É£º
ÈçºÎ×öÄØ£¿
¸Õ²ÅÊÔÁËÏ£¬µã¡°¿ªÊ¼¡±--¡°ÊÓͼ¡±--¡°Éè¼ÆÊÓͼ¡±²»ÐÐ
PS£ºÎÒÓõÄÊÇaccess 2007£¬ÉÏÃæÕâ¸ö±íÊÇmdb¸ñʽµÄ
Ö÷²Ëµ¥£¬ ÊÓͼ ......
DbgridÁ¬½Óaccess ÏÔʾÊý¾ÝʱÍ϶¯¹ö¶¯ÌõËÀ»ú£¿Ôõô½â¾ö°¡£¿
»úÆ÷Ì«²îÁ˰ɣ¿
ÊDz»ÊÇÄãÊý¾ÝÁ¿Ì«´óÁ˰¡
ÄãÊý¾ÝÉÙһЩ¿´¿´»¹ËÀ»úÂð£¿
Êý¾ÝºÜÉÙ°¡ ¾ÍÒ»Ò³¡£
ÎÒÔÚBCB6ÏÂ×ö¹ý²»ÉÙ DBGRID+ACCESS £¬´ÓÀ´Ã»ÓÐÓöµ½ ......
ÔÚMSSQLÖУ¬ÎÒÃÇ¿ÉÒÔÒ»´Î²éѯ¶à¸öÊý¾Ý±í²¢¼ÓÈëµ½Êý¾Ý¼¯ÖУ¬ÖмäÖ»ÐèÓ÷ֺŸô¿ª£®È磺
£¢select * from A;select * from B;select * from C£¢,Ìî³äÊý¾Ý¼¯ºóÔÚDSÖоÍÓÐÁËÈýÕÅ±í£®
µ«ÔÚÓÃͬÑùµÄÓï¾ä·ÃÎÊACCESSÊý¾ ......
Çë¸÷λָµãÏ£º³ÌÐò´úÂëÈçÏÂmingchen = "C:\Îļþ·¾¶\"
cat = New ADOX.Catalog
cat.Create("Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & min ......