python - 属性错误: 'NoneType' object has no attribute 'DoCmd'

Question

无法弄清楚我做错了什么。这是代码:

import smtplib
import win32api,time
import pypyodbc
from win32com.client import Dispatch

DbName = 'C:/Users/billybob643/Documents/Database1.accb'
Access = Dispatch("Access.Application")
Access.OpenCurrentDatabase(DbName)
DbAccess = Access.CurrentDb()
DbAccess.DoCmd.RunMacro("00")

任何帮助将不胜感激。谢谢!

Answer 1

DoCmd 是 Access Application object 的成员.

通过您创建的Access.Application对象变量引用它...

Access.DoCmd.RunMacro("00")