sumit07 has asked for the wisdom of the Perl Monks concerning the following question:
Hi perl monks,
I badly need your help with this. I want to get the custom properties of ms Access files. I am able to open .mdb files but not .accdb files. Can any one help me with this.
When I tryto open .accdb files it saysmy $filename = "database.accdb"; # $ARGV[0]; print $filename."\n"; $oAccess = Win32::OLE->new('Access.Application') or die qq{Couldn't st +art new Access instance!}; # Open Access File $oDatabase = $oAccess->DBEngine->Workspaces(0)->OpenDatabase($filename +);
I also tried this codeOLE exception from "DAO.Workspace": Could not find file 'database.accdb'. Win32::OLE(0.1709) error 0x800a0bd0 in METHOD/PROPERTYGET "OpenDatabase" at accessTest.pl
But with this also it says file not found.my $filename = "database.accdb"; # $ARGV[0]; print $filename."\n"; $oAccess = Win32::OLE->new('Access.Application') or die qq{Couldn't st +art new Access instance!}; # Open Access File $oDatabase = $oAccess->OpenCurrentDatabase($filename);
Do I need to install any drivers for ms access or any thing like that.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Ms Access and win32 ole
by Sinistral (Monsignor) on Oct 25, 2012 at 13:55 UTC | |
by sumit07 (Novice) on Oct 26, 2012 at 08:56 UTC | |
by sumit07 (Novice) on Oct 26, 2012 at 10:43 UTC | |
by Sinistral (Monsignor) on Oct 26, 2012 at 13:50 UTC | |
Re: Ms Access and win32 ole
by rpnoble419 (Pilgrim) on Oct 25, 2012 at 11:17 UTC | |
Re: Ms Access and win32 ole
by sundialsvc4 (Abbot) on Oct 25, 2012 at 13:19 UTC | |
by Sinistral (Monsignor) on Oct 25, 2012 at 13:43 UTC | |
by sundialsvc4 (Abbot) on Oct 25, 2012 at 16:09 UTC |
Back to
Seekers of Perl Wisdom