
Microsoft Access is a database storage file that can be used for front-end and back-end programs such as Microsoft SQL Server, Oracle, and Sybase. Support for the object-based programming language helps them refer to an array of objects including legacy Data Access Objects, ActiveX Data Objects, and other components from ActiveX. It has been used by software developers, data architects, and power users to create applications as it’s supported by Visual Basic for Application. Once you have defined an Access database, select Test Connection to verify that BarTender successfully connects to the database.Microsoft Access is a database management system developed by Microsoft that’s used to store information for reference, reporting, and analysis. For more information, refer to the Windows' help documentation. Enter the database path and file name and/or provide the necessary security credentials to access the database. This option is disabled for OLE DB data sources that do not have a user ID or password.Ĭlick the Advanced button to open the Windows Data Link Properties dialog. The Save User Name and Password to BarTender Document option saves the login information as part of the open document. If the database requires a login, enter the user name and password into the corresponding fields.

Alternatively, you can click Browse and navigate to the desired database.

Type the path of the database into the File Name field.

There are two ways to select an Access database as your data source: Access databases end with the extension *.mdb (Access 2000-2003) or *.accdb (Access 2007). When you select Microsoft Access as the Database Platform in the Add Database Connection Wizard, you must select a specific database to use with BarTender. Access Database (Add Database Connection Wizard) Access Database
