SewerGEMS ModelBuilder Error

Vincent,

Please have a look at the following wiki entry that has a few different solutions for this issue. The easiest resolution is to open the 32 bit version of SewerGEMS and run ModelBuilder within it. You can always go back and open the file in the 64 bit version after you use ModelBuilder and save the file.

communities.bentley.com/.../9388.modelbuilder-error-microsoft-access-database-engine-2010-64-bit-is-required-to-access-this-data-source

Regards,
Mark

Option 2 doesn't really make sense to me. I need to have both the 32-bit and 64-bit versions of Access installed to make my 64-bit version of SewerGEMS talk with a file created with a 64-bit version of Excel? That seems illogical.

A colleague who also has Office 2013 but recently upgraded to SewerGEMS 08.05.11.116 was able to get ModelBuilder to recognize the workbook. Could upgrading my version help? Creating separate files in 32-bit SewerGEMS to import tables using ModelBuilder seems like a really sub-optimal solution; I understood it as a temporary workaround during the transition from a 32-bit world to 64-bit, but this has been an issue for several releases.

Can someone please contact me about this? Thanks.

Vincent,

The 32 vs. 64-bit applies to the architecture and memory bandwidth of the program and is independent of the model file.

When using the 64-bit version of SewerGEMS, all components inside the program must be 64-bit in order to work. This means that the 64-bit version of the Access Database Engine component is needed in order to work with external data sources like Excel spreadsheets. The 32-bit version of the Access Database Engine cannot run inside a 64-bit process.

The Access Database Engine is not the full-blown version of Microsoft Access but rather it is a prerequisite component that programs (including SewerGEMS) need to use in order to communicate with Office files like Excel spreadsheets and Access databases

So, the message you're seeing indicates that you're trying to use the 64-bit version of SewerGEMS but do not have the 64-bit Access Database Engine component installed. This component is not included as a prerequisite when installing SewerGEMS, because of a conflict on Microsoft's end - for some reason, they do not allow the 64-bit Access Database Engine to be installed after the 32-bit version.

So, the workaround mentioned in Option 2 is to uninstall the 32-bit version of the Access Database Engine (typically denoted as "2007"), install the 64-bit version (typically denoted as "2010"), then reinstall the 32-bit version. When installing in this order, both versions will be available and you'll be able to work with Excel data sources from within both the 32-bit and 64-bit versions of SewerGEMS.

As Mark mentioned, option 1 is the "quick fix", as you can simply open the 32-bit version of SewerGEMS (which is always installed alongside the 64-bit version), import your Excel spreadsheet, save the model, then reopen it in the 64-bit version. You do not need to create a separate model file - both the 32 and 64-bit versions of SewerGEMS can open any model file. From the linked article: "This only needs to be done once; you can import your data through Modelbuilder in the 32-bit version, save the model, then open the 64-bit version using your regular desktop shortcut."

Regarding the colleague who used version "08.05.11.116" - I assume you mean 08.11.05.116 - this is actually not a valid version of SewerGEMS - the latest is currently 08.11.05.113. We did have a few cumulative patch sets that mistakenly changed the version number, but this has since been corrected. So, I suspect that your colleague applied a patch to 08.11.05.113. This would not have an effect on the issue at hand; the information above still applies. I suspect your colleague is either using the 32-bit version of SewerGEMS, or they are using the 64-bit version and happen to have the 64-bit Access Database Engine component installed.

I have edited the wiki article in question to hopefully make some of this more clear.

I went to the location where the 32-bit version should be, and there is no SewerGEMS.exe file. The closest thing I see to that is a file called SewerGEMS.exe.config which I can't open. Prior to installing 08.11.05.113 (and yes, you are correct that the patch is what changed the version number to .116), I did have SewerGEMS.exe in this location. Why can't I locate it now?