Rummaging around inside an Access DB

Dale Strickland-Clark dale at
Wed Dec 6 08:25:03 EST 2000

Dale Strickland-Clark <dale at> wrote:

>I've been trying to dig some information out of an Access DB using Python. I need to access as much
>information as possible about the composition of all the reports. 
>After a few false starts and lots of head scratching (I can't find a help file on the object model
>anywhere!!), I found something in the Python Win32 distribution called, presumably
>written by Mark H.
>This helped a lot and produced a listing of all the reports but I can't seem to break into the
>Report object.
>This is what I've come up with so far:
>from win32com.client import Dispatch
>import sys
>eng = Dispatch("DAO.DBEngine.36")
>db = eng.OpenDatabase(sys.argv[1])
>rep = db.Containers.Item('Reports')
>for doc in rep.Documents:
>	print doc.Name
>Does anyone know how I can get at the cuts of the Report object? The only other properties I can

No! Not "cuts" but "guts", as in "internals". Sorry about that. I'm sur my tryping is getitng wosre.
Dale Strickland-Clark
Out-Think Ltd
Business Technology Consultants

More information about the Python-list mailing list