{"id":47,"date":"2008-03-24T14:18:14","date_gmt":"2008-03-24T05:18:14","guid":{"rendered":"http:\/\/knowhow.hirohiro716.com\/?p=47"},"modified":"2017-02-21T17:01:59","modified_gmt":"2017-02-21T08:01:59","slug":"vb%e3%81%8b%e3%82%89adb%e3%81%a7mdb%e3%81%ab%e3%82%a2%e3%82%af%e3%82%bb%e3%82%b9%e3%81%99%e3%82%8b","status":"publish","type":"post","link":"https:\/\/weblog.hirohiro716.com\/?p=47","title":{"rendered":"VB\u304b\u3089ADO\u3067MDB\u306b\u30a2\u30af\u30bb\u30b9\u3059\u308b"},"content":{"rendered":"<p>\u53c2\u7167\u8a2d\u5b9a\u3067\u300cMicrosoft ActiveX Data Objects X.X Library\u300d\u3092\u8ffd\u52a0\u3059\u308b<br \/>\nCurrentProject.BaseConnectionString\u3092\u5e38\u6642\u4f7f\u7528\u3059\u308b\u3068\u69d8\u3005\u306aAccess\u672c\u6765\u306e\u6a5f\u80fd\u306b\u4e0d\u5177\u5408\u304c\u51fa\u308b\u306e\u3067\u3001\u6392\u4ed6\u30ed\u30c3\u30af\u304c\u5fc5\u8981\u306a\u5834\u5408\u4ee5\u5916\u306f\u5927\u4eba\u3057\u304fCurrentProject.Connection\u3092\u4f7f\u7528\u3059\u308b\u306e\u304c\u826f\u3044\u3068\u601d\u3046\u3002\u6b63\u76f4\u3001Access\u3067ADO\u4f7f\u3046\u306e\u9762\u5012\u304f\u3055\u3044\u3002<\/p>\n<pre class=\"brush: vb; title: ADO\u30b5\u30f3\u30d7\u30eb; notranslate\" title=\"ADO\u30b5\u30f3\u30d7\u30eb\">\r\nDim connection As ADODB.connection\r\nDim recordset As ADODB.recordset\r\n\r\n&#039;ACCESS\u4ee5\u5916\u304b\u3089\u306e\u63a5\u7d9a\u306f\u3053\u3063\u3061\u3092\u4f7f\u3046\r\n&#039;Set connection = New ADODB.connection\r\n&#039;2000\uff5e2003\r\n&#039;connection.Open &quot;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\test.mdb&quot;\r\n&#039;2007\uff5e\r\n&#039;connection.Open &quot;Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\test.accdb&quot;\r\n\r\n&#039;ACCESS\u5185\u306e\u63a5\u7d9a\u306f\u3053\u3063\u3061\u3092\u4f7f\u3046\r\nSet connection = New ADODB.Connection\r\nconnection.ConnectionString = CurrentProject.BaseConnectionString\r\nconnection.Open\r\n\r\nSet recordset = New ADODB.recordset\r\n\r\nrecordset.Open &quot;SELECT * FROM test;&quot;, connection, adOpenKeyset, adLockPessimistic\r\n\r\nDo While recordset.EOF = False\r\n    Debug.Print recordset.Fields(0).Value\r\n    Debug.Print recordset.Fields(&quot;column&quot;).Value\r\n    recordset.MoveNext\r\nLoop\r\n\r\nrecordset.Close\r\nconnection.Close\r\n\r\nSet recordset = Nothing\r\nSet connection = Nothing\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u53c2\u7167\u8a2d\u5b9a\u3067\u300cMicrosoft ActiveX Data Objects X.X Library\u300d\u3092\u8ffd\u52a0\u3059\u308b CurrentProject.BaseConnectionString\u3092\u5e38\u6642\u4f7f\u7528\u3059\u308b\u3068\u69d8\u3005\u306aAccess\u672c\u6765\u306e [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":["post-47","post","type-post","status-publish","format-standard","hentry","category-vb-vba"],"views":6117,"_links":{"self":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts\/47","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=47"}],"version-history":[{"count":1,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions"}],"predecessor-version":[{"id":566,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=\/wp\/v2\/posts\/47\/revisions\/566"}],"wp:attachment":[{"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=47"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=47"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/weblog.hirohiro716.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=47"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}