When I tried to open an old Access 2000 database, I get this in the GUI:

Not sure what more info you need.

Ian

LLBLGen Pro version 4.2. Build July 8th, 2014 -----[Core exception]-------------------- at System.Data.OleDb.OleDbConnectionInternal.ProcessResults(OleDbHResult hr) at System.Data.OleDb.OleDbConnectionInternal.GetSchemaRowset(Guid schema, Object[] restrictions) at System.Data.OleDb.OleDbConnection.GetOleDbSchemaTable(Guid schema, Object[] restrictions) at SD.LLBLGen.Pro.DBDrivers.Access.AccessCatalogRetriever.RetrieveUniqueConstraints(DBCatalog catalogMetaData) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v4.2\Drivers\Access\AccessCatalogRetriever.cs:line 61 at SD.LLBLGen.Pro.DBDrivers.Access.AccessCatalogRetriever.<ProduceAdditionalActionsToPerform>b__10(DBCatalog catalog) in c:\Myprojects\VS.NET Projects\LLBLGen Pro v4.2\Drivers\Access\AccessCatalogRetriever.cs:line 117 at SD.LLBLGen.Pro.DBDriverCore.DBCatalogRetriever.PerformAdditionalActions(String catalogName, DBCatalog catalogMetaData, IEnumerable1 actionsToPerform) at SD.LLBLGen.Pro.DBDriverCore.DBCatalogRetriever.RetrieveCatalog(String catalogName, List1 elementsToRetrieve) at SD.LLBLGen.Pro.DBDriverCore.DBDriverBase.PopulateCatalogs(Dictionary2 callBacks, Dictionary2 elementsToRetrieve) at SD.LLBLGen.Pro.Gui.Classes.GuiController.ObtainMetaDataFromDatabase(DBDriverBase driverUsed, Dictionary`2 selectedElements)

Hi Ian,

Do you have linked tables in your access file? Because the exception message and stack trace suggests that. Ref: http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=4158

Other Access MDB's link to it, but it has no linked tables. It's the "source". Just dumb tables. I tried moving the mdb where no other mdbs know about it, thinking that could help, but it still fails.

I assume that's still a problem?

It could be some UC (unique constraint) or another thing in some table, but I would be guessing.

• How many tables do you have?
• Could you identify the problematic one?
• Is it feasible for you to attach your mdb file (just the schema, no data) in a HelpDesk thread (which is private)?

(Edit) - I'm not sure, but it also could be reserved words in your table/columns/uc names.

Yes, how do I send it to Helpdesk?

ianvink wrote:

Yes, how do I send it to Helpdesk?

You open a new thread in the HelpDesk forum ( http://www.llblgen.com/TinyForum/Threads.aspx?ForumID=33 )

Done - Helpdesk Thread #22941

The following is copied from the docs:

For MS Access 2007/2010/2013, an OleDB ACE driver v12 or higher is required.

Please note:
If you want to run LLBLGen Pro on a 64bit windows system and you want to retrieve Relational Model Data from an MS Access database, you will run into the limitation that Microsoft still hasn't shipped a 64bit MS Access JET driver. To overcome this, please run the LLBLGen Pro designer as a 32bit application. To do so, please use the 32bit enforcer helper executable LLBLGenPro_x86.exe which is located in the LLBLGen Pro installation folder and which will run the designer in 32bit, regardless whether you have a 64bit OS or not.

If you want to use the newer Microsoft Access Database Engine (ACE driver) which is supported on 64bit windows and which can also work with .accdb files (MS Access 2007/2010/2013), please visit this link at the Microsoft download center to obtain the engine to make the LLBLGen Pro MS Access driver work properly on 64bit and with .accdb files.

I am running LLBL in 32 bit and have all the drivers needed. In fact LLBL does show me all the tables in the old access database so is talking to the db correctly.

The problem happens in LLBL when we try to finish the refresh option after I choose the tables.

LLBL crashes out at that stage.

Followed in HelpDesk. I will close this one for now.