This project has moved. For the latest updates, please go here.

type lib won't load

Jan 12, 2012 at 2:30 PM

After having entered the path to the mdb, I get the following err msg:

---------------------------
Access Source Control
---------------------------
Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY))
---------------------------
OK  
---------------------------

and only the tables are loaded.

Win7 Pro 64bit EN, Office 2010 Pro EN. VisualSVN Server v2.5.2, Subversion 1.7.2, Apache 2.2.21

Coordinator
Jan 13, 2012 at 1:00 PM

Hi

You need to have installed the dao library. This library is not installed by default in x64 platform.

AccessSVN is very coupled to this library. You can get it installing Access2003 or downloading the jet engine from Microsoft. AccessSVN is compiled for x32 platform.

Jan 13, 2012 at 6:43 PM

Hi mnieto,

getting dao360.dll is not the point. I guess it would have been in an Access runtime as well. I got it from my "XP-mode" where Access 2000 is installed.

I regsvr32'ed dao360.dll in %CommonProgramFiles(x86)%\microsoft shared\DAO. Nothing changed. Now I had a look if DAO is deactivated (killbit) with Nirsoft's ActiveXhelper. Every entry for dao360.dll is enabled. My experience with these DAO issues points rather to Office / Access 2010 than to Windows 7 and 64bit. The Compatibility flags list didn't show any killbit, but reflects that uncontrollable (?) mixture of dao360.dll and acedao.dll substitution Access 14 prefers from just supporting old DAO when referenced in an Access file.

ActiveX List

Created by using ActiveXHelper

CLSID ProgID Description Control Status Missing File Product Name Company File Description File Version Threading Model Filename Modified Date
{CD7791B9-43FD-42C5-AE42-8DD2811F0419} DAO.DBEngine.120 DAO.DBEngine.120 No Enabled No Microsoft Office 2010 Microsoft Corporation Microsoft Access database engine Data Access Object Library 14.0.6015.1000 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL 10.08.2011 12:12:28
{00000100-0000-0010-8000-00AA006D2EA4} DAO.DBEngine.36 DAO.DBEngine.36 No Enabled No Microsoft® Jet Microsoft Corporation Microsoft DAO 3.6 Object Library 03.60.9756.0 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\DAO\dao360.dll 14.07.2009 05:53:53
{A1EB89D6-0A9C-4575-A0AE-654A990A454C} DAO.Field.120 DAO.Field.120 No Enabled No Microsoft Office 2010 Microsoft Corporation Microsoft Access database engine Data Access Object Library 14.0.6015.1000 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL 10.08.2011 12:12:28
{00000104-0000-0010-8000-00AA006D2EA4} DAO.Field.36 DAO.Field.36 No Enabled No Microsoft® Jet Microsoft Corporation Microsoft DAO 3.6 Object Library 03.60.9756.0 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\DAO\dao360.dll 14.07.2009 05:53:53
{97A2762C-403C-4953-A121-7A75ABCE4373} DAO.Group.120 DAO.Group.120 No Enabled No Microsoft Office 2010 Microsoft Corporation Microsoft Access database engine Data Access Object Library 14.0.6015.1000 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL 10.08.2011 12:12:28
{00000106-0000-0010-8000-00AA006D2EA4} DAO.Group.36 DAO.Group.36 No Enabled No Microsoft® Jet Microsoft Corporation Microsoft DAO 3.6 Object Library 03.60.9756.0 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\DAO\dao360.dll 14.07.2009 05:53:53
{8D4F994C-EBBE-4F8D-BA4B-AE20CD36E72D} DAO.Index.120 DAO.Index.120 No Enabled No Microsoft Office 2010 Microsoft Corporation Microsoft Access database engine Data Access Object Library 14.0.6015.1000 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL 10.08.2011 12:12:28
{00000105-0000-0010-8000-00AA006D2EA4} DAO.Index.36 DAO.Index.36 No Enabled No Microsoft® Jet Microsoft Corporation Microsoft DAO 3.6 Object Library 03.60.9756.0 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\DAO\dao360.dll 14.07.2009 05:53:53
{6F3DD387-5AF2-492B-BDE2-30FF2F451241} DAO.PrivateDBEngine.120 DAO.PrivateDBEngine.120 No Enabled No Microsoft Office 2010 Microsoft Corporation Microsoft Access database engine Data Access Object Library 14.0.6015.1000 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL 10.08.2011 12:12:28
{00000101-0000-0010-8000-00AA006D2EA4} DAO.PrivateDBEngine.36 DAO.PrivateDBEngine.36 No Enabled No Microsoft® Jet Microsoft Corporation Microsoft DAO 3.6 Object Library 03.60.9756.0 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\DAO\dao360.dll 14.07.2009 05:53:53
{D5EC4D34-77DA-4F7A-B8C4-8A910C1C1CFE} DAO.QueryDef.120 DAO.QueryDef.120 No Enabled No Microsoft Office 2010 Microsoft Corporation Microsoft Access database engine Data Access Object Library 14.0.6015.1000 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL 10.08.2011 12:12:28
{00000108-0000-0010-8000-00AA006D2EA4} DAO.QueryDef.36 DAO.QueryDef.36 No Enabled No Microsoft® Jet Microsoft Corporation Microsoft DAO 3.6 Object Library 03.60.9756.0 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\DAO\dao360.dll 14.07.2009 05:53:53
{D0B22D03-D05D-4C6D-8AB7-9392E84A87B9} DAO.Relation.120 DAO.Relation.120 No Enabled No Microsoft Office 2010 Microsoft Corporation Microsoft Access database engine Data Access Object Library 14.0.6015.1000 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL 10.08.2011 12:12:28
{00000109-0000-0010-8000-00AA006D2EA4} DAO.Relation.36 DAO.Relation.36 No Enabled No Microsoft® Jet Microsoft Corporation Microsoft DAO 3.6 Object Library 03.60.9756.0 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\DAO\dao360.dll 14.07.2009 05:53:53
{367E582C-F71C-4BF9-AA1B-9F62B793E9C5} DAO.TableDef.120 DAO.TableDef.120 No Enabled No Microsoft Office 2010 Microsoft Corporation Microsoft Access database engine Data Access Object Library 14.0.6015.1000 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL 10.08.2011 12:12:28
{00000103-0000-0010-8000-00AA006D2EA4} DAO.TableDef.36 DAO.TableDef.36 No Enabled No Microsoft® Jet Microsoft Corporation Microsoft DAO 3.6 Object Library 03.60.9756.0 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\DAO\dao360.dll 14.07.2009 05:53:53
{805B7F91-C9CF-4EDF-ACA6-775664FDFB3E} DAO.User.120 DAO.User.120 No Enabled No Microsoft Office 2010 Microsoft Corporation Microsoft Access database engine Data Access Object Library 14.0.6015.1000 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL 10.08.2011 12:12:28
{00000107-0000-0010-8000-00AA006D2EA4} DAO.User.36 DAO.User.36 No Enabled No Microsoft® Jet Microsoft Corporation Microsoft DAO 3.6 Object Library 03.60.9756.0 Apartment C:\Program Files (x86)\Common Files\Microsoft Shared\DAO\dao360.dll 14.07.2009 05:53:53

 

OK, so, any suggestions what to do to make dao360.dll really available to AccessSVN? Compatibility settings or something?

Or do you think other libraries might be in question to be blamed as well?

Or is your answer just: Use a 32bit platform!?

I will try if AccessSVN works in "XP-mode", but I don't think I will use that on a regular basis. If we do not find a solution for the DAO / type lib issue I rather further maintain the SaveDbAsText module I inherited and amended for our project and get familiar with TortoiseSVN or svn.exe and svnadmin.exe. When the project is exported to text files completely, most of the work AccessSVN does is done, right?

Coordinator
Jan 19, 2012 at 9:12 PM

Hi mupan

Thanks for your response. It's a large response ;-)

I have developed the application on Vista, 32bits and Access 2003

Last commit was tested successfuly on Win7 x64, with both, Access 2003 and Access 2010 (The trick is Access 2003 witch install dao properly).

Sorry, for now, I don't have posibilty to test with only Access 2010. In next versions its possible that I could use NetOffice - MS Office in .NET to make AccessSVN version independent.

Have do you downloaded the source code? In Microsoft.Office.Interop.Access reference properties, try to switch the specific version property to false.

 

thanks for your comments.

Jan 26, 2012 at 2:05 AM

Hi mnieto,

yes, it is, forces my browser to scroll horizontally or zoom the page too. But I thought it would be good to show that Office 2010 is special not only in regard to DAO, but esp. there, unfortunately. Making our Access project fit for 2010 while preserving 2000 compatibility has increased my grey hair share to a visible extent.

I assume that in Sharp one may, can and should control the use of libs and their versions in the project code (unlike VBA). So you don't need to think about any system configuration changes to ensure the use of dao360. I compared the list with that from XP and 2000 and found that ProgIDs have not changed. One would not expect ProgIDs to change but hey it's M$.

I downloaded accesssvn-9684.zip now but did not succeed to open the project in VS 2008 nor SharpDevelop 4.1 8000. I tried to open it via the .sln file. It was partially loaded but the Microsoft.Office.Interop.Access didn't show up as a reference, and even if, I would not have had any chance to compile the project. Since I don't know Sharp I was forced to give up then.

Thank you for your answer too.

mupan