mdb_prop: Get Properties List From MDB Database

In mdbr: Work with Microsoft Access Files

Get Properties List From MDB Database

Description

mdb-prop retrieves properties for one or more objects in an MDB database. name is the name of the table, query, or other object. propcol is the name of the MSysObjects column containing properties and defaults to LvProp.

Usage

mdb_prop(
  path,
  name = NULL,
  propcol = "LvProp",
  version = FALSE,
  as_list = TRUE
)

Arguments

path	Path to .mdb/.accdb file.
name	Object name (table, query, etc.); may be a character vector.
propcol	Property column name. Defaults to LvProp.
version	Logical; when TRUE, return mdbtools version.
as_list	Logical; defaults to TRUE. When TRUE, wraps the result in an mdblist object so the dedicated print method is used.

Value

A named list with one entry per element of name. Each entry is itself a named list of named character vectors, one per property block (e.g. "(none)" for table-level properties, or a column/field name). Access individual values with p[["Orders"]][["(none)"]]["Description"].

Examples

db <- mdbr:::.mdb_example_nwind_path()
if (nzchar(db)) {
  p <- mdb_prop(db, "Orders")
  p[["Orders"]][["(none)"]]["Description"]
  p2 <- mdb_prop(db, c("Orders", "Orders Qry"))
}

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