获取ACCESS mdb文件版本

Access2000和Access2003生成的mdb文件如何区别？

把下面脚本复制到记事本里，再保存为GetMdbVer.vbs，运行后可以获得mdb文件的版本。

Set objAccess = CreateObject("Access.Application")
objAccess.OpenCurrentDatabase "C:\Users\octob\Desktop\Database2.mdb"

intFormat = objAccess.CurrentProject.FileFormat
Select Case intFormat
    Case 2 Wscript.Echo "Microsoft Access 2" 
    Case 7 Wscript.Echo "Microsoft Access 95"
    Case 8 Wscript.Echo "Microsoft Access 97" 
    Case 9 Wscript.Echo "Microsoft Access 2000"
    Case 10 Wscript.Echo "Microsoft Access 2003"
End Select

获得版本。注意，获取结果可能会稍有延迟。

参考

How Can I Determine Which Version of Access was Used to Create a Database?