Actions
Backport #2947
closedwin32ole & MS Access 2007
Status:
Closed
Assignee:
-
Description
=begin
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.
=end
Files
Actions
Like0
Like0Like0