mdb_tables: List tables in a Microsoft Access database

In mdbr: Work with Microsoft Access Files

List tables in a Microsoft Access database

Description

mdb-tables is a utility program distributed with MDB Tools. It outputs the names of all user tables (or other object types) in an MDB database file.

Usage

mdb_tables(
  file,
  system = FALSE,
  type = c("table", "query", "systable", "any", "all", "form", "macro", "report",
    "linkedtable", "module", "relationship", "dbprop"),
  show_type = FALSE
)

Arguments

file	Path to the Microsoft Access file.
system	Logical; include system (⁠MSys*⁠) tables. Equivalent to -S.
type	Object type to list: "table" (default), "query", "systable", "any", "all", "form", "macro", "report", "linkedtable", "module", "relationship", or "dbprop". Equivalent to -t.
show_type	Logical; prefix each entry with its type. Equivalent to -T.

Value

A character vector of object names.

Examples

db <- mdb_example()
mdb_tables(db)
mdb_tables(db, type = "query")

mdbr documentation built on May 28, 2026, 5:09 p.m.