Contar tablas de Access desde ASP.NET

[Andres95]

Con el framework 1.1, utilizando DAO...solo hay que agregar la referencia COM correspondiente a la version de la base de datos.

Ejemplo...

Código:

Dim dbsNorthwind As Database
Dim wo As workSpace
Dim workSpace As workSpace
Dim eng As New DAO.DBEngine

Dim tdfNew As TableDef
Dim tdfLoop As TableDef
Dim prpLoop As DAO.Property

Try
    workSpace = eng.CreateWorkspace("Norte", "Admin", "", DAO.WorkspaceTypeEnum.dbUseJet)
    dbsNorthwind = workSpace.OpenDatabase("c:\Northwind.mdb", , , "UID=Admin;PWD=")

    With dbsNorthwind
        Response.Write("<br>" & .TableDefs.Count)

        ' Enumerate TableDefs collection.
        For Each tdfLoop In .TableDefs
            Response.Write("<br>" & tdfLoop.Name)


        Next tdfLoop
        .Close()
    End With


Catch ex As Exception
    Response.Write(ex.ToString)
End Try