现在网络上有一共享的access数据库,我想使用ado访问,但是我把打开的source设为
共享路径,如:\\10.0.0.125\ShareAccess\MyData.mdb,结果提示打开出错,是根本就不允许这样作还是我的程序有问题,请高手多多指教!

解决方案 »

  1.   

    a)MS Remote - Access (Jet)
        i)ODBC DSN:
            oConn.Open "Remote Server=http://carl2;" & _ 
                "Remote Provider=MSDASQL;" & _
                "DSN=AdvWorks;" & _
                "Uid=admin" & _
                "Pwd=;" 
        ii)OLE DB Provider:
            oConn.Open "Provider=MS Remote;" & _ 
                "Remote Server=http://carl2;" & _
                "Remote Provider=Microsoft.Jet.OLEDB.4.0;" & _
                "Data Source=\somepath\mydb.mdb;", _
                "admin", ""
        iii)OLE DB Provider×Ô¶¨ÒåÊÂÎñ¶ÔÏó
            oConn.Open "Provider=MS Remote;" & _ 
                "Remote Server=http://carl2;" & _
                "Handler=MSDFMAP.Handler;" & _
                "Data Source=MyAdvworksOLEDBConnectTag;"
    b)MS Remote - SQL Server
        i)ODBC DSN:
            oConn.Open "Remote Server=http://carl2;" & _ 
                "Remote Provider=MSDASQL;" & _
                "Network Library=DBMSSOCN;" & _
                "DSN=Pubs;" & _
                "Uid=sa" & _
                "Pwd=;" 
        ii)OLE DB Provider
            oConn.Open "Provider=MS Remote;" & _ 
                "Remote Server=http://carl2;" & _
                "Remote Provider=SQLOLEDB;" & _
                "Network Library=DBMSSOCN;" & _
                "Data Source=carl2;" & _
                "Initial Catalog=pubs;" & _
                "User ID=sa;" & _
                "Password=;"
      

  2.   

    www.csdn.net elite 
    Reposted by: ghj1976 
    From: http://www.active.com.cn