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

ADO ACCESS »ñÈ¡±íÃû

BOOL GetAllTables(LPCTSTR databasefile,CStringArray & dbtables)
    {
       //#import "msado15.dll" no_namespace rename("EOF", "adoEOF")   //¿½±´ msado15.dll µ½¹¤³ÌĿ¼
       _ConnectionPtr m_pConnection;    
        _RecordsetPtr m_pRecordset;    
        HRESULT hr;    
        try        
        { 
            CoInitialize(NULL);
            hr = m_pConnection.CreateInstance(__uuidof(Connection));
            hr =m_pRecordset.CreateInstance(__uuidof(Recordset));
           
            if(SUCCEEDED(hr))            
            {  
                CString strconnection;            
                strconnection.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=%s",databasefile);            
                hr = m_pConnection->Open((_bstr_t)strconnection,"","",adModeUnknown);            
                m_pRecordset = m_pConnection->OpenSchema(adSchemaTables);        &nb


Ïà¹ØÎĵµ£º

½â¾öVSSÖÐAccess to file "rights.dat" deniedµÄ´íÎó

1¡¢VSS¿Í»§¶Ë´ò¿ª¹¤³ÌʱÌáʾ Access to file"\\***\rights.dat" denied
 ¸ÃÌáʾÊÇָûÓÐÍøÂç·ÃÎʵÄȨÏÞ£¬Óû§ÒªÔÚ¹²ÏíÎļþ¼ÐÓпÉдµÄȨÏ޲ſÉÒÔ¡£ÎÒÃÇÔÚÉèÖù²ÏíÎļþµÄʱºòÓ¦¸ÃÔÊÐíдÈë¡£
2¡¢ÎªVSSÉèÖû·¾³±äÁ¿
 Ä¬ÈÏÇé¿öÏÂÎÒÃÇÿ´Î´ò¿ªVSS¿Í»§¶ËÌî³äµÄÓû§Ãû¶¼Êǵ±Ç°ÏµÍ³µÇ½µÄÓû§£¬ÕâÑùʹÓÃÆðÀ´ºÜ²»·½±ã¡£Î ......

VBÁ¬½ÓACCESSÊý¾Ý¿â¾«¼ò°æ

Option Explicit
Private Sub Form_Load()
'¹¤³Ì->ÒýÓÃ->Ñ¡ÖÐMicrosoft ActiveX Data Objects 2.8 Library
Dim shujukulianjie As New ADODB.Connection
Dim jiluji As New ADODB.Recordset
'Á¬½ÓÊý¾Ý¿âµÄ´úÂë¶Î
shujukulianjie.Open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=False;Data Sour ......

access ÖеÄÎı¾µ½Êý¾ÝÀàÐ͵Äת»»

ÓÃCdbl()ÊÔÊÔ
CDbl(str)   -->   Ë«¾«¶È
CInt(str)   -->   ÕûÐÍ
CLng(str)   -->   ³¤ÕûÐÍ
CSng(str)   -->   µ¥¾«¶È
CDate(str)   -->   ÈÕÆÚÐÍ ......

ACCESSÊý¾Ý¿â´æ´¢´óÅúÁ¿²É¼¯ÐÅÏ¢µÄÎÊÌâ

ÓÉÓÚ¹¤×÷ÐèÒª£¬Ê¹ÓÃACCESSÊý¾Ý¿â´æ´¢¸Û¿ÚÖÜΧAISÉ豸½ÓÊÕµ½µÄ´¬²°Êý¾Ý¡£ÓÉÓÚÔÚÈ«¹úºÜ¶à¸Û¿ÚÓвɼ¯µã£¬Òò´Ë£¬Êý¾ÝÁ¿ºÜ´ó£¬Ã¿Èý·ÖÖÓ´æ´¢Ò»´ÎÊý¾ÝµÄ»°£¬ÄÇôһ´Î½«ÓÐ2000¶àеĴ¬Î»Êý¾Ý¡£ÕâЩÊý¾ÝÈë¿âºó£¬Êý¾Ý¿âÎļþ´óС½«ÐÂÔö1Mµ½2M×óÓÒ¡£¸ù¾ÝÕâ¸öƵÂÊ£¬Ò»¸öСʱÊý¾Ý¿âÎļþ½«Ôö¼Ó40M£¬Ò»Ìì¾ÍÊÇ960M¡£
ΪÁËÌá¸ßÊý¾Ý¿âЧÂÊ£¬ÎÒ ......

asp.net AccessÊý¾Ý¿âÁ¬½Ó×Ö·û´®

 <connectionStrings>
  <add  name="qxConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Web/App_Data/db2.mdb;"  providerName="System.Data.OleDb"/>
 </connectionStrings> ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ