Microsoft Access Advanced Parameter Settings

The Import/Export Wizard provides default values. Although other parameters may be available through the ODBC Administrator, UPS recommends that you use the parameters below.

Note: All versions of Microsoft Access use the *.mdb file extension.

Attribute Name

Basic/
Advanced

Optional/
Required

Default
Value

Description

DBQ

Basic

Required

The same option as Database in the Set Up window.

Description

Basic

Optional

The same option as Description in the Set Up window.

MAXBUFFERSIZE

Advanced

Required

2048

The size of the internal buffer, in kilobytes.

PAGETIMEOUT

Advanced

Required

5

The period of time, in milliseconds, that a page (if not used) remains in the buffer before being removed.

PWD

Advanced

Optional

The password of the access DB.

READONLY

Advanced

Required

0

TRUE to make file read-only.

UID

Advanced

Optional

The user ID name used for login.