From: Philippe Lang <redmine@...>
Date: 2010-03-10T00:09:31+09:00
Subject: [ruby-core:28580] [Bug #2947] win32ole & MS Access 2007

Bug #2947: win32ole & MS Access 2007
http://redmine.ruby-lang.org/issues/show/2947

Author: Philippe Lang
Status: Open, Priority: Normal
Target version: Ruby 1.8.6
ruby -v: ruby 1.8.6 (2010-02-04 patchlevel 398) [i386-mingw32] or ruby 1.8.6 (2007-09-24 patchlevel 111) [i386-mswin32] 

Hi,

When opening a MS Access database with ruby code like

----------------------------------------------
require 'win32ole'
access = WIN32OLE.new('Access.Application')
database = File.expand_path('db2000.mdb')
access.OpenCurrentDatabase(database, false)
access.DoCmd.OpenReport("rptTest")
access.Visible = true
----------------------------------------------

... database is opened read-write with MS Access 2000/2003, and ***read-only*** with MS Access 2007.

I have made tests under Window 7 with ruby 1.8.6 patchlevel 111 and patchlevel 398.

Database format is not an issue: the same problem happens with a database in 2000 (mdb) or 2007 (accdb) format.

I'm not sure if that's a ruby bug or a MS Access limitation, but vbs code like

----------------------------------------------
Set objAcc = WScript.CreateObject("Access.Application")
strDBName = "C:\Users\Philippe Lang\Desktop\db2000.mdb"
objAcc.OpenCurrentDatabase strDBName
objAcc.run "get_document_lines_store", "1234", "L", "1"
objAcc.DoCmd.OpenReport "rptTest", 2, "", ""
objAcc.Visible = true
----------------------------------------------

... opens the database read-write, whatever version of MS Access we use.


----------------------------------------
http://redmine.ruby-lang.org