Microsoft Access 2007 Tips

Access 2007 installs normally within Office 2007 Professional pack.
There is a dependency problem that doesn't let the program to start:

fixme:actctx:parse_depend_manifests Could not find dependent assembly L"AceDAO" (12.0.0.0)
err:module:import_dll Library MSVCP80.dll (which is needed by L"C:\\Program Files\\Microsoft Office\\Office12\\MSACCESS.EXE") not found
err:module:LdrInitializeThunk Main exe initialization for L"C:\\Program Files\\Microsoft Office\\Office12\\MSACCESS.EXE" failed, status c0000135

There are several ways to "fix" this - that means to decline dependency and force the program run without possibilities offered by ACEDAO module.

1 way:

1) Create file "acedao.manifest" (to be saved as UTF-8) with content (or you can extract it with Resource Editor from ACEDAO.DLL as described here):

<assembly xmlns="urn:schemas-microsoft-com:asm.v1" manifestVersion="1.0"><assemblyIdentity type="win32" name="AceDAO" version="12.0.0.0" processorArchitecture="x86"></assemblyIdentity><dependency><dependentAssembly><assemblyIdentity type="win32" name="Microsoft.VC80.CRT" version="8.0.50608.0" processorArchitecture="x86" publicKeyToken="1fc8b3b9a1e18e3b"></assemblyIdentity></dependentAssembly></dependency><file name="acedao.dll"><comClass clsid="{00000100-0000-0010-8000-00AA006D2EA4}" progid="DAO.DBEngine.36"></comClass><comClass clsid="{00000101-0000-0010-8000-00AA006D2EA4}" progid="DAO.PrivateDBEngine.36"></comClass><comClass clsid="{00000103-0000-0010-8000-00AA006D2EA4}" progid="DAO.TableDef.36"></comClass><comClass clsid="{00000104-0000-0010-8000-00AA006D2EA4}" progid="DAO.Field.36"></comClass><comClass clsid="{00000105-0000-0010-8000-00AA006D2EA4}" progid="DAO.Index.36"></comClass><comClass clsid="{00000106-0000-0010-8000-00AA006D2EA4}" progid="DAO.Group.36"></comClass><comClass clsid="{00000107-0000-0010-8000-00AA006D2EA4}" progid="DAO.User.36"></comClass><comClass clsid="{00000108-0000-0010-8000-00AA006D2EA4}" progid="DAO.QueryDef.36"></comClass><comClass clsid="{00000109-0000-0010-8000-00AA006D2EA4}" progid="DAO.Relation.36"></comClass><comClass clsid="{CD7791B9-43FD-42C5-AE42-8DD2811F0419}" progid="DAO.DBEngine.120"></comClass><comClass clsid="{6F3DD387-5AF2-492B-BDE2-30FF2F451241}" progid="DAO.PrivateDBEngine.120"></comClass><comClass clsid="{367E582C-F71C-4BF9-AA1B-9F62B793E9C5}" progid="DAO.TableDef.120"></comClass><comClass clsid="{A1EB89D6-0A9C-4575-A0AE-654A990A454C}" progid="DAO.Field.120"></comClass><comClass clsid="{8D4F994C-EBBE-4F8D-BA4B-AE20CD36E72D}" progid="DAO.Index.120"></comClass><comClass clsid="{97A2762C-403C-4953-A121-7A75ABCE4373}" progid="DAO.Group.120"></comClass><comClass clsid="{805B7F91-C9CF-4EDF-ACA6-775664FDFB3E}" progid="DAO.User.120"></comClass><comClass clsid="{D5EC4D34-77DA-4F7A-B8C4-8A910C1C1CFE}" progid="DAO.QueryDef.120"></comClass><comClass clsid="{D0B22D03-D05D-4C6D-8AB7-9392E84A87B9}" progid="DAO.Relation.120"></comClass></file></assembly>

2) go to the folder where the Office 2007 is installed (e.g.: ~/.cxoffice/Microsoft Office 2007/drive_c/Program Files/Microsoft Office/Office12);
3) copy acedao.manifest to this folder and rename ACEDAO.DLL (e.g. to ACEDAO.DLL.OLD).

2 way:

1) go to the folder where the Office 2007 is installed (e.g.: ~/.cxoffice/Microsoft Office 2007/drive_c/Program Files/Microsoft Office/Office12);
2) copy (backup) msaccess.exe.manifest to msaccess.exe.manifest.old
3) edit the file msaccess.exe.manifest with your favourite text editor:

• delete the text block:

<dependency><dependentAssembly><assemblyIdentity type="win32" name="AceDAO" version="12.0.0.0" language="*" processorArchitecture="X86"></assemblyIdentity></dependentAssembly></dependency>

4) save the file

This changes let run the Access 2007.

• The forms, quieries and standart macroses work well. DBs and tables are created/edited with no problems. Simple macroses and SQL quieries work fine;
  
• You can get error notification (unable to open dll) - which doesn't break the work;
• No wizards will work;
• In Crossover 9.0.0 and wine 1.1.41 you won't be able to create/edit the forms' objects (this is a regression as in wine 1.1.31 it was possible to edit forms and even to launch form autocreation wizard with error notifications);  see the tip: Forms' controls and linked fields update for subforms
• When you try to launch the wizard (e.g. to create a form), you get empty dialogue and there is no way other to get back to database then to force-kill the application (make sure you saved everything in other windows applications as the whole bottle is restarted! go to main menu - Crossover - Terminate Windows Applications - choose the bottle with Office 2007 - press Reset and than Force kill);
• There is a bug when you work with subforms - adding the new record to tables works, but doesn't automatically update linked fields - only solution to make this fields visible and edit them manualy within the subform (otherwise, as the newly created record field is empty, you will not get the items linked correctly and won't see the new record when you return to current main form record). see the tip: Forms' controls and linked fields update for subforms