Access.Database

This function retrieves a structural overview of an Access database. It includes an optional parameter called options that can be used to adjust specific settings. The options include CreateNavigation...

Syntax

Access.Database(database as binary, optional options as nullable record) as table

About

This function retrieves a structural overview of an Access database. It includes an optional parameter called options that can be used to adjust specific settings. The options include CreateNavigationProperties, which determines whether navigation properties should be included in the output (default is false), and NavigationPropertyNameGenerator, which is a function that generates names for navigation properties.

Explanation

The record parameter is defined with a list of options and corresponding values, such as option1 with value1, option2 with value2, and so on.