1  """db_table_names.py -- a simple demo for ADO database table listing."""
   2  
   3  import sys
   4  
   5  import adodbapi
   6  
   7  try:
   8      databasename = sys.argv[1]
   9  except IndexError:
  10      databasename = "test.mdb"
  11  
  12  provider = ["prv", "Microsoft.ACE.OLEDB.12.0", "Microsoft.Jet.OLEDB.4.0"]
  13  constr = "Provider=%(prv)s;Data Source=%(db)s"
  14  
  15  # create the connection
  16  con = adodbapi.connect(constr, db=databasename, macro_is64bit=provider)
  17  
  18  print("Table names in= %s" % databasename)
  19  
  20  for table in con.get_table_names():
  21      print(table)
  22