1. Select Tools > Database Linking
2. In the Database Links dialog, select Add Connection (advanced)
3. In the Data Link Properties dialog, check if you have a Provider called Microsoft Office 12 Access Database Engine OLE DB Provider

1. Download the Access driver install from this page: https://www.microsoft.com/en-za/download/details.aspx?id=13255


Click the red Download button Choose the AccessDatabaseEngine_X64.exe option (put a tick in the box just to the left of it) and click Next The file AccessDatabaseEngine_X64.exe should be downloaded to your Downloads folder


2. Run the AccessDatabaseEngine_X64 installer from the command line with /passive option:


Open Windows Explorer and go to your Downloads folder

Open a command window in the Downloads folder. EITHER:

Hold down the Shift key and right-click in the empty space just to the left of the files listed. Then choose Open command window here from the pop-up options, OR

Select File > Open Command Prompt from the menu

In the command window, type 'AccessDatabaseEngine_X64 /passive' (without the quotes) and press the Enter key:







If you are prompted to allow changes, click Yes

The Access driver should install in a few seconds

Close the command window


3. Go back to step 1 to check that the 64-bit Access driver has installed

print friendly version