I saw the request about https://gallery.technet.microsoft.com/scriptcenter/site/requests/Access-database-to-upgrade-285f532a

user need to know the version of access DB, I have created it for local 

 

Using the script access database other parameters can also extracted and further used for next operations 

One can pass array of computer list and invoke the script to get versions on all the VM machines too

 

PowerShell
Edit|Remove
function Get-AccessDBVersions { 
 
$hash=@() 
Set-Location -Path C:\ 
$activeDriveget-wmiobject Win32_LogicalDisk | where {$_.drivetype -eq 3} | % {get-psdrive $_.deviceid[0]} 
 
foreach ($drive in $activeDrive.root) { 
$Dir = get-childitem $drive -recurse -ErrorAction SilentlyContinue | where {$_.extension -eq ".accdb"| % { 
        Write-Host $_.FullName 
         
        $hash +New-Object psobject -Property @{Property1 = $_.FullName} 
        } 
    } 
     
       foreach ($f in $hash) { 
        $access=New-Object -com Access.Application 
        $access.OpenCurrentDatabase($f.Property1) 
        #$access.OpenCurrentDatabase('C:\Users\USER\Documents\Database1.accdb') 
       
        write-output $f '-->' $access.version 
        $access.Quit() 
       } 
} 
 
Get-AccessDBVersions 
 
<# 
In addition user can use below properties like 
write-output $access.application or 
write-output $access.Build 
 
$access.Application         
$access.Parent              
$access.CodeContextObject   
$access.MenuBar             
$access.CurrentObjectType   
$access.CurrentObjectName   
$access.Forms               
$access.Reports             
$access.Screen              
$access.DoCmd               
$access.ShortcutMenuBar     
$access.Visible             
$access.UserControl         
$access.DBEngine            
$access.CommandBars         
$access.Assistant           
$access.References          
$access.Modules             
$access.FileSearch          
$access.IsCompiled          
$access.VBE                 
$access.DataAccessPages     
$access.ADOConnectString    
$access.CurrentProject      
$access.CurrentData         
$access.CodeProject         
$access.CodeData            
$access.WizHook             
$access.ProductCode         
$access.COMAddIns           
$access.Name                
$access.DefaultWebOptions   
$access.LanguageSettings    
$access.AnswerWizard        
$access.FeatureInstall      
$access.VGXFrameInterval    
$access.BrokenReference     
$access.Printers            
$access.Printer             
$access.MsoDebugOptions     
$access.Version             
$access.Build               
$access.NewFileTaskPane     
$access.AutoCorrect         
$access.AutomationSecurity  
$access.MacroError          
$access.TempVars            
$access.Assistance          
#>