Edit

Share via

Understanding the Customization File

  • Article

Applies to: Access 2013, Office 2013

Each section header in the customization file consists of square brackets ([]) containing a type and parameter. The four section types are indicated by the literal strings connect, sql, userlist, or logs. The parameter is the literal string, the default, a user-specified identifier, or nothing.

Therefore, each section is marked with one of the following section headers:

 
[ connect   default     ]
[ connect   identifier  ]
[ sql       default     ]
[ sql       identifier  ]
[ userlist  identifier  ]
[ logs                  ]

The section headers have the following parts.

Part

Description

connect

A literal string that modifies a connection string.

sql

A literal string that modifies a command string.

userlist

A literal string that modifies the access rights of a specific user.

logs

A literal string that specifies a log file recording operational errors.

default

A literal string that is used if no identifier is specified or found.

identifier

A string that matches a string in the connect or command string.

  • Use this section if the section header contains connect and the identifier string is found in the connection string.

  • Use this section if the section header contains sql and the identifier string is found in the command string.

  • Use this section if the section header contains userlist and the identifier string matches a connect section identifier.

The DataFactory calls the handler, passing client parameters. The handler searches for whole strings in the client parameters that match identifiers in the appropriate section headers. If a match is found, the contents of that section are applied to the client parameter.

A particular section is used under the following circumstances:

  • A connect section is used if the value part of the client connect string keyword, "**Data Source=value", matches a connect section identifier.

  • An sql section is used if the client command string contains a string that matches an sql section identifier.

  • A connect or sql section with a default parameter is used if there is no matching identifier.

  • A userlist section is used if the userlist section identifier matches a connect section identifier. If there is a match, the contents of the userlist section are applied to the connection governed by the connect section.

  • If the string in a connection or command string does not match the identifier in any connect or sql section header, and there is no connect or sql section header with a default parameter, then the client string is used without modification.

  • The logs section is used whenever the DataFactory is in operation.