Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation
 
PerlMonks  

Ms Access and win32 ole

by sumit07 (Novice)
on Oct 25, 2012 at 10:51 UTC ( [id://1000819]=perlquestion: print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
     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->DBEngine->Workspaces(0)->OpenDatabase($filename
    +);
    
  2. or download this
    OLE exception from "DAO.Workspace":
    
    Could not find file 'database.accdb'.
    
    Win32::OLE(0.1709) error 0x800a0bd0
        in METHOD/PROPERTYGET "OpenDatabase" at accessTest.pl
    
  3. or download this
     
    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);
    

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://1000819]
Approved by Ratazong
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others scrutinizing the Monastery: (4)
As of 2024-03-28 23:12 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found