Others

Connect Microsoft Access to an Epicor Vista 6 Database

Camila MilosovichCamila Milosovich Nov 13, 2026 869 views

Question details

The user needs to connect Microsoft Access to an Epicor Vista 6 database that does not appear during ODBC setup.

How to Connect Microsoft Access to an Epicor Vista 6 Database
Product
Microsoft Access and Epicor Vista 6
Device & OS
not provided
Scenario
Creating an ODBC connection to use Epicor Vista 6 data in Microsoft Access.
Observed behavior
The Epicor Vista 6 database does not appear when the user attempts to create an ODBC connection.
Before you start

In Access, check File > Account > About Access for the installed Office bitness. Ask your Epicor administrator which database system Vista 6 uses and for the connection details and permissions.

Solution 1Recommended

Check the ODBC driver and create a data source

Use this approach to check whether a driver compatible with your Access installation is available and configure the connection.

A missing database may mean that the required ODBC driver or data source has not been configured. Epicor Vista 6 is an older product, and a compatible driver may be available only in 32-bit form.

The driver must match the bitness of Access. If only a 32-bit driver is available, 32-bit Access is generally required to use it directly.

1
Check Access bitness

In Access, select File > Account > About Access and look for 32-bit or 64-bit in the version information.

2
Open the matching ODBC administrator

For 32-bit Access on 64-bit Windows, run C:\Windows\SysWOW64\odbcad32.exe. For 64-bit Access, search Windows for ODBC Data Sources (64-bit).

3
Check the driver list

Open the Drivers tab and look for the driver for the database system used by Epicor Vista 6. If it is missing, ask Epicor or the database vendor for a compatible driver and installation instructions.

4
Configure a data source

After installing the matching driver, reopen ODBC Data Source Administrator, select User DSN or System DSN, and click Add. Choose the driver and enter the connection settings supplied by your administrator.

5
Connect from Access

In Access, select External Data > New Data Source > From Other Sources > ODBC Database. Choose whether to import or link data, then select the configured data source and provide credentials if prompted.

Check the ODBC driver and create a data source
Driver availability varies: Microsoft supplies ODBC drivers for only selected database systems. Contact Epicor to confirm the database type and whether a driver compatible with your Access version is available.
Free Microsoft Office alternative

Work with exported Epicor data in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface and Microsoft Office format compatibility for a smooth transition. Use WPS Spreadsheets to review Epicor data exported to a supported spreadsheet file; it does not fix the Access ODBC connection.

Review and analyze exported database data in WPS SpreadsheetsOpen and edit Microsoft Excel XLSX filesUse a familiar interface for everyday document and spreadsheet workWork with a free, lightweight office suite
QA img-9

Frequently Asked Questions

Why doesn't the Epicor database appear in the ODBC setup?

The required driver or data source may not be configured, or you may be using the wrong ODBC administrator for your Access bitness. Check the Drivers tab in the matching ODBC Data Source Administrator.

Where can I find the 32-bit ODBC administrator on 64-bit Windows?

Run C:\Windows\SysWOW64\odbcad32.exe to open the 32-bit ODBC Data Source Administrator.

Can 64-bit Access use a 32-bit ODBC driver directly?

No. The ODBC driver must match the bitness of Access. If the only compatible driver is 32-bit, ask your administrator about using 32-bit Access.

Who can provide the driver for Epicor Vista 6?

Contact Epicor to confirm the underlying database system and driver availability. The database vendor may provide the appropriate ODBC driver.

How do I link the configured data source in Access?

Select External Data > New Data Source > From Other Sources > ODBC Database, choose the option to link data, and select your configured data source.