{"id":278,"date":"2016-10-05T20:07:18","date_gmt":"2016-10-05T11:07:18","guid":{"rendered":"http:\/\/okamurax.com\/?p=278"},"modified":"2024-10-25T08:26:54","modified_gmt":"2024-10-24T23:26:54","slug":"access%e3%81%ae%e3%83%97%e3%83%ad%e3%83%91%e3%82%a4%e3%83%80%e3%81%ab%e3%81%a4%e3%81%84%e3%81%a6%e3%80%81access%e3%81%ae%e3%83%87%e3%83%bc%e3%82%bf%e3%82%92mysql%e3%81%b8%e3%82%a8%e3%82%af%e3%82%b9","status":"publish","type":"post","link":"https:\/\/appbay.org\/?p=278","title":{"rendered":"Access \u30e1\u30e2"},"content":{"rendered":"<h2>DB\u30a8\u30f3\u30b8\u30f3(JET)<\/h2>\n<p>JET\u306fOS32bit\u5c02\u7528(JET\u81ea\u4f5332bit\u306e\u307f)\u306a\u306e\u3067OS64bit\u3067\u52d5\u304b\u3059\u5834\u5408\u3001<br \/>\n32bit\u30d7\u30ed\u30b0\u30e9\u30e0\u307e\u305f\u306f32bitOffice\u3067\u52d5\u304b\u3059\u3002(WOW64\u3067\u52d5\u304b\u3059)<br \/>\n\u307e\u305f\u3001JET\u306faccdb\u3092\u4f7f\u3048\u306a\u3044\u3002<br \/>\n(Access\u304b\u3089\u76f4\u63a5mdb\/accdb\u3092\u64cd\u4f5c\u3059\u308b\u5834\u5408\u306f\u95a2\u4fc2\u306a\u304f\u300164bitAccess\u304b\u3089mdb\u3092\u958b\u304f\u3053\u3068\u3082\u53ef\u80fd)<\/p>\n<p>\u4ee5\u524d\u306fOS\u6a19\u6e96\u3067\u642d\u8f09\u3055\u308c\u3066\u3044\u305f\u305f\u3081\u3001\u8ffd\u52a0\u3067\u518d\u9812\u5e03\u53ef\u80fd\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u304c\u306a\u304f\u4fbf\u5229\u3060\u3063\u305f\u304c\u3001\u73fe\u5728\u306f\u975e\u63a8\u5968\u3002<\/p>\n<p>\u30fbOS64bit\/64bit\u30d7\u30ed\u30b0\u30e9\u30e0<br \/>\n\u5229\u7528\u3067\u304d\u306a\u3044\u3002<br \/>\n\u30fbOS64bit\/32bit\u30d7\u30ed\u30b0\u30e9\u30e0(32bitOffice)<br \/>\n<span style=\"color: #0000ff;\">&#8220;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=xxx.mdb&#8221;<br \/>\n<\/span>\u306f\u5229\u7528\u3067\u304d\u308b\u3002<br \/>\n<span style=\"color: #0000ff;\">&#8220;Provider=Microsoft.Jet.OLEDB.4.0;Data Source=xxx.accdb&#8221;<br \/>\n<\/span>\u306f\u5229\u7528\u3067\u304d\u306a\u3044\u3002<\/p>\n<h2>DB\u30a8\u30f3\u30b8\u30f3(ACE)<\/h2>\n<p>ACE\u306fOS32\/64bit(ACE\u81ea\u4f53\u304c32\/64bit\u5b58\u5728\u3059\u308b)\u3067\u3082\u4f7f\u3048\u308b\u3002<br \/>\nmdb\/accdb\u304c\u4f7f\u3048\u308b\u3002<\/p>\n<p>\u30fbOS32bit\/32bit\u30d7\u30ed\u30b0\u30e9\u30e0(32bitOffice)<br \/>\n\u30fbOS64bit\/32bit\u30d7\u30ed\u30b0\u30e9\u30e0(32bitOffice)<br \/>\n\u30fbOS64bit\/64bit\u30d7\u30ed\u30b0\u30e9\u30e0(64bitOffice)<br \/>\n<span style=\"color: #0000ff;\">&#8220;Provider=Microsoft.ACE.OLEDB.12.0;Data Source=xxx.mdb&#8221;<\/span><br \/>\n<span style=\"color: #0000ff;\">&#8220;Provider=Microsoft.ACE.OLEDB.12.0;Data Source=xxx.accdb&#8221;<\/span><span style=\"color: #0000ff;\"><br \/>\n<\/span>\u3059\u3079\u3066\u5229\u7528\u3067\u304d\u308b\u3002<\/p>\n<p>\u30d1\u30b9\u30ef\u30fc\u30c9\u4ed8\u304d\u306emd\/accdb\u3092\u958b\u304f\u5834\u5408\u3001<br \/>\n<span style=\"color: #0000ff;\">&#8220;Provider=Microsoft.ACE.OLEDB.12.0;Data Source=xxx.mdb\/accdb;&#8221; &amp; &#8220;Jet OLEDB:Database Password=xxx&#8221;<br \/>\n<\/span>OS64bit\/32bit\u3001OS64bit\/64bit\u30d7\u30ed\u30b0\u30e9\u30e0\u3069\u3061\u3089\u3067\u3082\u5229\u7528\u3067\u304d\u308b\u3002<\/p>\n<p>OS\u6a19\u6e96\u3067\u5165\u3089\u306a\u3044\u306e\u3067\u3001Access\u3084\u518d\u9812\u5e03\u53ef\u80fd\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u306a\u3069\u304c\u5fc5\u8981\u3002<br \/>\n\u203b32bit\u306eOffice\u304c\u5165\u3063\u3066\u3044\u308b\u5834\u5408\u3001AccessDatabaseEngine_x64.exe \/quiet<\/p>\n<h2>DB\u30a8\u30f3\u30b8\u30f3\u78ba\u8a8d<\/h2>\n<pre class=\"lang:ps decode:true \">(New-Object data.oledb.oledbenumerator).getElements() | select sources_name, sources_description<\/pre>\n<p>\u306b\u3066\u78ba\u8a8d\u3067\u304d\u308b\u300232bit\u3092\u78ba\u8a8d\u3057\u305f\u3044\u5834\u5408\u3001<br \/>\n<span style=\"color: #0000ff;\">%systemroot%\\syswow64\\windowspowershell\\v1.0\\powershell.exe<\/span><br \/>\n\u306ePowerShell\u3092\u8d77\u52d5\u3059\u308b\u3002<\/p>\n<h2>ADO\u3068DAO\u306e\u9055\u3044<\/h2>\n<p>DAO\u306fJET\u30a8\u30f3\u30b8\u30f3\u3092\u5bfe\u8c61\u306b\u958b\u767a\u3055\u308c\u3001Access\u5c02\u7528\u3002<br \/>\nADO\u306fAccess\u4ee5\u5916\u3082\u5bfe\u8c61\u3002OLEDB\u3092\u5229\u7528\u3059\u308b\u3002<\/p>\n<h2>VBA(ADO)\u3067\u306e\u5229\u7528<\/h2>\n<pre class=\"lang:vb decode:true\">Sub test()\r\n\r\n' \u53c2\u7167\u8a2d\u5b9a\u3057\u306a\u3044\u5834\u5408\r\nDim cn1 As Object\r\nSet cn1 = CreateObject(\"ADODB.Connection\")\r\n\r\n' \u53c2\u7167\u8a2d\u5b9a\u3059\u308b\u5834\u5408(Microsoft ActiveX Data Objects X.X Library)\r\nDim cn2 As ADODB.Connection\r\nSet cn2 = New ADODB.Connection\r\n\r\ncn1.Open \"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\" &amp; ThisWorkbook.Path &amp; \"\\test.mdb;\" &amp; \"Jet OLEDB:Database Password=abc;\"\r\n\r\nDim rs As Object\r\nSet rs = cn1.Execute(\"select * from tbl\")\r\n\r\nActiveCell.CopyFromRecordset rs\r\n\r\nIf rs.State = 1 Then rs.Close\r\nSet rs = Nothing\r\n \r\nIf cn1.State = 1 Then cn1.Close\r\nSet cn1 = Nothing\r\n\r\nEnd Sub<\/pre>\n<p>\u53d6\u5f97\u65b9\u6cd5\u306e\u7a2e\u985e<\/p>\n<pre class=\"lang:vb decode:true\">'\u53d6\u5f97\u65b9\u6cd5\u2460\r\nDo Until rs.EOF\r\n  Debug.Print rs!xxx '\u30ec\u30b3\u30fc\u30c9\u30bb\u30c3\u30c8 !\u30de\u30fc\u30af \u30d5\u30a3\u30fc\u30eb\u30c9\u540d\u3068\u3044\u3046\u9806\u756a\u3067\u6307\u5b9a\u3067\u304d\u308b\u3002\r\n  rs.MoveNext\r\nLoop\r\nrs.MoveFirst\r\n\r\n'\u53d6\u5f97\u65b9\u6cd5\u2461\r\nFor c = 1 To rs.Fields.Count\r\n  w.Cells(1, c).Value = rs.Fields(c - 1).Name\r\nNext c\r\nw.Cells(2, 1).CopyFromRecordset rs\r\n\r\n'\u53d6\u5f97\u65b9\u6cd5\u2462\r\nDo Until rs.EOF\r\n  Debug.Print rs.Fields(\"xxx\") '\u30ec\u30b3\u30fc\u30c9\u30bb\u30c3\u30c8 files (\"\u540d\u79f0\") \u3042\u308b\u3044\u306f (0\uff5eindex) \u306a\u3069\u3067\u6307\u5b9a\u3067\u304d\u308b\r\n  rs.MoveNext\r\nLoop<\/pre>\n<h2>OLEDB\u30c9\u30e9\u30a4\u30d0\u304c\u306a\u3044<\/h2>\n<p>Excel\u304b\u3089Access\u63a5\u7d9a\u3057\u305f\u3044\u306a\u3068\u601d\u3063\u305f\u3089\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u53ef\u80fd\u306a ISAM \u30c9\u30e9\u30a4\u30d0\u304c\u898b\u3064\u304b\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3068\u8a00\u308f\u308c\u305f\u3002<\/p>\n<p>\u3069\u3046\u3084\u3089\u4ee5\u4e0b\u3092\u8aad\u3080\u3068\u30012016\/32bit(\u30b5\u30d6\u30b9\u30af\u30ea\u30d7\u30b7\u30e7\u30f3)\u304c\u30af\u30a4\u30c3\u30af\u5f62\u5f0f\u3067\u5165\u3063\u3066\u3044\u3066\u3001\u30c9\u30e9\u30a4\u30d0\u304c\u5165\u3089\u306a\u3044\u3068\u3044\u3046\u3053\u3068\u3089\u3057\u3044\u3002<\/p>\n<p><span style=\"color: #0000ff;\">https:\/\/blogs.technet.microsoft.com\/officesupportjp\/2016\/09\/06\/not_available_access_odbc_oledb_outside_c2r_applications\/<\/span><\/p>\n<p><span style=\"color: #0000ff;\">https:\/\/blogs.technet.microsoft.com\/officesupportjp\/2016\/09\/08\/howto_c2r_or_msi\/<\/span><\/p>\n<h2>MySQL\u3078\u306e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8<\/h2>\n<p>DSN\u3092\u4f5c\u3063\u3066\u304a\u304f\u3068\u81ea\u52d5\u3067\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u3067\u304d\u308b\u3068\u306e\u3053\u3068\u3002<\/p>\n<p><span style=\"color: #0000ff;\">http:\/\/dev.mysql.com\/downloads\/connector\/odbc\/<\/span><br \/>\n\u304b\u3089msi\u30d5\u30a1\u30a4\u30eb\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3002<\/p>\n<p><span style=\"color: #0000ff;\">\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u30d1\u30cd\u30eb\uff1e\u7ba1\u7406\u30c4\u30fc\u30eb\uff1eODBC\u30c7\u30fc\u30bf\u30bd\u30fc\u30b9\uff1e\u30e6\u30fc\u30b6\u30fc DSN\uff1e\u8ffd\u52a0<\/span><br \/>\nAccess\u3092\u8d77\u52d5\u3057\u3066\u30c6\u30fc\u30d6\u30eb\u30c7\u30b6\u30a4\u30f3\u3092\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\u5148\u306eMySQL\u3068\u5408\u308f\u305b\u308b\u3002<br \/>\n\u30c6\u30fc\u30d6\u30eb\u3092\u9078\u629e\u3057\u3001<br \/>\n<span style=\"color: #0000ff;\">\u53f3\u30af\u30ea\u30c3\u30af\uff1e\u30a8\u30af\u30b9\u30dd\u30fc\u30c8\uff1eODBC \u30c7\u30fc\u30bf\u30bd\u30fc\u30b9<\/span><br \/>\n(\u3059\u3067\u306b\u5b58\u5728\u3057\u3066\u3044\u308b\u30c6\u30fc\u30d6\u30eb\u306b\u4e0a\u66f8\u304d\u306f\u3067\u304d\u306a\u3044)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DB\u30a8\u30f3\u30b8\u30f3(JET) JET\u306fOS32bit\u5c02\u7528(JET\u81ea\u4f5332bit\u306e\u307f)\u306a\u306e\u3067OS64bit\u3067\u52d5\u304b\u3059\u5834\u5408\u3001 32bit\u30d7\u30ed\u30b0\u30e9\u30e0\u307e\u305f\u306f32bitOffice\u3067\u52d5\u304b\u3059\u3002(WOW64\u3067\u52d5\u304b\u3059) \u307e\u305f\u3001JET\u306faccdb &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/appbay.org\/?p=278\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;Access \u30e1\u30e2&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-278","post","type-post","status-publish","format-standard","hentry","category-1"],"_links":{"self":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/278","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=278"}],"version-history":[{"count":24,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/278\/revisions"}],"predecessor-version":[{"id":6512,"href":"https:\/\/appbay.org\/index.php?rest_route=\/wp\/v2\/posts\/278\/revisions\/6512"}],"wp:attachment":[{"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/appbay.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}