python repair修复功能,如何通过Python脚本压缩和修复Access数据库

崔海龙

于 2021-03-01 06:05:28 发布

阅读量272

点赞数

文章标签： python repair修复功能

本文介绍了一种使用Python脚本通过win32com库调用VBA方法CompactRepair()来压缩和修复Access个人地理数据库的方法。此过程需要创建一个尚不存在的备份文件路径，在成功压缩后该备份文件可以被删除。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

I have a python script running from an ArcGIS custom toolbox. The script deals with Access databases (mostly personal geodatabases). What I am wondering is, is there a way to compact and repair an access database (specifically a personal gdb) from my python script?

Thanks in advance for any help and advice,

Ben.

解决方案

Use Python's win32com library and make a call to the VBA method CompactRepair(). Do note, a backup file path is required (one that does not exist yet) during the process but can be deleted after successful compact, using os.remove() for that need:

import os

import win32com.client

srcDB = 'C:\\Path\\To\\Database.accdb'

destDB = 'C:\\Path\\To\\Database_backup.accdb'

oApp = win32com.client.Dispatch("Access.Application")

oApp.compactRepair(srcDB, destDB)

os.remove(destDB)

oApp = None