	Applies To
	Product(s):	AutoPIPE
	Version(s):	All
	Area:	Message
	Original Author:	Bentley Technical Support Group
	Date Logged & Current Version	April. 2020 12.03.00.17

Problem:

The following warning is displayed when using AutoPIPE:

---------------------------
Bentley AutoPIPE
---------------------------
Unable to open the asme2010.mdb database
---------------------------
OK
---------------------------

Why and How to avoid it?

Solution:

Solution #1: User Permission

Do you have the correct user permission to be running Microsoft Access commands on your Computer?

As a first step, suggest to run the application in Administrator Mode.

Does this resolve the issue:

If yes, great!! continue using the application.

If no, continue below.

Solution #2: Confirm folders exist

Open the following folder and check that the file is actually present:

C:\ProgramData\Bentley\AutoPIPE 20xx

and

C:\Program Files\Bentley\AutoPIPE 20xx

Note: if the program folder is under Program Files (x86), uninstall AutoPIPE completely, remove AutoPIPE user Profile folders, download a fresh installer, install AutoPIPE, and reboot your computer..

If missing, perform the following:

1. Ask around, if there is a person who is using the same exact version and ask that they send you their file (asme2010.mdb) from their program installation folder.

2. After receiving the asme2010.mdb file, place it in the same exact location on your computer.

3. Reboot your computer

4. Start AutoPIPE

Does this resolve the issue?

If Yes, great!! continue using the application.

If No continue below

Solution #3: Using Office x64 and update Database engine

Answer these 2 questions

1. Does the computer have Microsoft Word and Access x64 bit installed?

Watch video below to see what office version is currently being used.

2. Is "Microsoft Access Database Engine" installed?

Note: most MDB issues are often caused by this tool

If no to either question above, uninstall the existing "Microsoft Access database engine" application using Windows "Add and Remove Programs" application, use link here to download a 32 bit version of this application, and install the newly downloaded application. Next, reboot your computer and try to use AutoPIPE.

If yes to both question, continue below

Note, just to be safe, recommend uninstalling, downloading, and reinstalling "Microsoft Access database engine" from here.

Solution #4: Using Windows x64

Are you installing AutoPIPE 23.00.01.367 or higher on a 32-bit computer or with 32-bit MS Office?

If yes, note that AutoPIPE 23.00.01.367 and higher must be installed on a full 64 bit computer running Microsoft office 64. Therefore, the only options you have are:

1. 1. Update computer to 64-bit with MS Office 64-bit
  2. Role back to a previous version of AutoPIPE that supports installation on a 32-bit computer with MS Office 32-bit.

Please see KB here if trying to download AutoPIPE and a specific version is not available.

Solution #5: Using AutoPIPE 24 and higher with MS Office 32 bit

AutoPIPE 23.00.01 and higher installs and uses Microsoft Office 64bit files (Microsoft engine 2016 X64).

After installing AutoPIPE 2023.00.01 or higher, start the AutoPIPE for a brief moment, close the application, and delete the following registry Key:

a. Open the Registry Editor by typing "regedit" in the Windows search box under the Start menu and select 'regedit.exe'.

b. Delete or rename the "mso.dll" registry value in the following registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Common\FilesPaths

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Common\FilesPaths

Notes:

1. The entry in registry may not show up unless you install AutoPIPE and open the software at least on time.

2. If you do not delete the "mso.dll" registry value, you may get a "Reconfiguring" message every time you open up an Office application.

Solution #6: Using AutoPIPE 12.01 or higher

A known problem occurs when running Support optimization, when two or more models are opened accessing the same file (asme2010.mdb). This issues was fixed in AutoPIPE 12.01 and higher (956393). Confirm version of AutoPIPE and upgrade to latest version of the program as needed.

Solution #7: Correctly install AutoPIPE

During installation some files were not installed correctly. Therefore, follow these steps below:

1. Close all but one instance of AutoPIPE before before continuing below.

2. Open Preferences dialog - click here.

3. Click on each Explorer button to open their folder locations in different File Explorer windows.

4. Next, close the current AutoPIPE application.

5. At this point, all AutoPIPE applications should be closed and 2 Windows of File Explorer are opened

6. Go to each File Explorer window (User Profile path and Program Data path) that was opened from step above, and delete AutoPIPE folder

Example:

7. Next, Use standard Windows procedure for uninstalling applications, Uninstall AutoPIPE.

8. Reboot the computer.

9. Download a fresh installation file from Bentley's Software downloads page

10. Install AutoPIPE

11. Start AutoPIPE.

Does this resolve the issue?

If Yes, great!! continue using the application.

If No continue below

Note: If this issue is occurring in the latest version where the above does not resolve the issue, please file a new Case mentioning this WIKI page.

"Unable to open the asme2010.mdb database"... Bentley AutoPIPE message is displayed in the program?

Problem:

Solution:

See Also