Access オブジェクト

Last-modified: 2023-04-10 (月) 01:44:06

すべてのテーブル名を取得するには

    Dim objAccessObject As AccessObject

    For Each objAccessObject In Application.CurrentData.AllTables
        Debug.Print objAccessObject.Name

    Next
    Dim objTableDef As TableDef

    For Each objTableDef In Application.CurrentDb.TableDefs
        Debug.Print objTableDef.Name

    Next