在python中运行已保存的MS Access宏：错误

Question

我正在尝试使用python运行保存的msaccess宏。但是，在执行代码时，出现了一个错误：

Traceback (most recent call last):
  File "test.py", line 7, in <module>
    objAccess.OpenCurrentDatabase(strDbName)
  File "<COMObject Access.Application>", line 3, in OpenCurrentDatabase
  File "C:\Users\ash\AppData\Local\Continuum\anaconda3\lib\site-packages\win32com\client\dynamic.py", line 287, in _ApplyTypes_
    result = self._oleobj_.InvokeTypes(*(dispid, LCID, wFlags, retType, argTypes) + args)
pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, None, "Microsoft Access can't open the database because it is missing, or opened exclusively by another user, or it is not an ADP file.", None, -1, -2146820422), None)

• 文件存在。你知道吗

• 无密码保护 -我甚至在查询开始时抑制了所有警告（SetWarnings:No）

  import win32api,time
  from win32com.client import Dispatch
  
  strDbName = 'testing.accdb'
  objAccess = Dispatch("Access.Application")
  objAccess.Visible = False
  objAccess.OpenCurrentDatabase(strDbName)
  objDB = objAccess.CurrentDb()
  objAccess.DoCmd.RunMacro('test')
  objAccess.Application.Quit()