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
Ïà¹ØÎĵµ£º
1¡¢VSS¿Í»§¶Ë´ò¿ª¹¤³ÌʱÌáʾ Access to file"\\***\rights.dat" denied
¸ÃÌáʾÊÇָûÓÐÍøÂç·ÃÎʵÄȨÏÞ£¬Óû§ÒªÔÚ¹²ÏíÎļþ¼ÐÓпÉдµÄȨÏ޲ſÉÒÔ¡£ÎÒÃÇÔÚÉèÖù²ÏíÎļþµÄʱºòÓ¦¸ÃÔÊÐíдÈë¡£
2¡¢ÎªVSSÉèÖû·¾³±äÁ¿
ĬÈÏÇé¿öÏÂÎÒÃÇÿ´Î´ò¿ªVSS¿Í»§¶ËÌî³äµÄÓû§Ãû¶¼Êǵ±Ç°ÏµÍ³µÇ½µÄÓû§£¬ÕâÑùʹÓÃÆðÀ´ºÜ²»·½±ã¡£Î ......
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 ......
ÓÃCdbl()ÊÔÊÔ
CDbl(str) --> Ë«¾«¶È
CInt(str) --> ÕûÐÍ
CLng(str) --> ³¤ÕûÐÍ
CSng(str) --> µ¥¾«¶È
CDate(str) --> ÈÕÆÚÐÍ ......
ÓÉÓÚ¹¤×÷ÐèÒª£¬Ê¹ÓÃACCESSÊý¾Ý¿â´æ´¢¸Û¿ÚÖÜΧAISÉ豸½ÓÊÕµ½µÄ´¬²°Êý¾Ý¡£ÓÉÓÚÔÚÈ«¹úºÜ¶à¸Û¿ÚÓвɼ¯µã£¬Òò´Ë£¬Êý¾ÝÁ¿ºÜ´ó£¬Ã¿Èý·ÖÖÓ´æ´¢Ò»´ÎÊý¾ÝµÄ»°£¬ÄÇôһ´Î½«ÓÐ2000¶àеĴ¬Î»Êý¾Ý¡£ÕâЩÊý¾ÝÈë¿âºó£¬Êý¾Ý¿âÎļþ´óС½«ÐÂÔö1Mµ½2M×óÓÒ¡£¸ù¾ÝÕâ¸öƵÂÊ£¬Ò»¸öСʱÊý¾Ý¿âÎļþ½«Ôö¼Ó40M£¬Ò»Ìì¾ÍÊÇ960M¡£
ΪÁËÌá¸ßÊý¾Ý¿âЧÂÊ£¬ÎÒ ......
<connectionStrings>
<add name="qxConnectionString" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Web/App_Data/db2.mdb;" providerName="System.Data.OleDb"/>
</connectionStrings> ......