Cannot Load The Ole 2.0 Or Doc File Libraries
- Cannot Load The Ole 2.0 Or Doc File Librariesor Doc File Libraries
- Cannot Load The Ole 2.0 Or Doc File Libraries Online
- The cswinrt.exe tool consumes WinMD metadata files that define the WinRT libraries and generates interop.NET 5 and.NET Standard 2.0 C# code. This interop code uses the winrt.runtime.dll library. As you can guess, the cswinrt.exe gets all the WinUI WinMD files and generates C# interop code.NET 5 code for the WinUI library.
- Features of C# 2.0 New features in C# for the.NET SDK 2.0 (corresponding to the 3rd edition of the ECMA-334 standard) are: Partial class Partial classes allow implementation of a class to be spread between several files, with each file containing one or more class members. It is primary useful when parts of a class are automatically generated.
This feature is called OLE Objects, and it’s simple to do. In the “Insert” tab of your ribbon, under the “Text” section, there’s a button for “Object”. From here, you can use the “Create from File” tab to embed your file. Ensure “Link to file” is NOT checked, otherwise the file won’t be embedded. Your embedded object.
Microsoft Access Tips for Serious Users
Provided by Allen Browne, June 2002. Updated April 2010.
Libraries are components that provide functionality. Access itself and its programming language (VBA) are two essential libraries in every project. If Access does not provide something you need (such as a calendar or tree-view), you may be able to find a library and add it. However, adding extra libraries increases the number of things that can go wrong.
What Problems?
Installing or uninstalling any software may overwrite, remove, or de-register libraries. Then simple functions like Date() or Trim() don't work.
To see what libraries an Access project has referenced, open any code window (e.g. press Ctrl+G), and choose References from the Tools menu.
If a library is marked MISSING, click the Browse button, and locate the correct file for the library. The table below lists the files for the crucial libraries of your version of Access.
If the library is not even shown, you may need to re-register it. Click the Windows Start button, and choose Run. Enter regsvr32 followed by the full path of the library file. Include quotes if the file name contains spaces, e.g.:
regsvr32 'c:program filescommon filesmicrosoft shareddaodao360.dll'
Occasionally, the problem is not solved until you unregister the library and re-register it. Uncheck the missing library in Access. Close Access. Issue this command, and then the one above to re-register it:
regsvr32 -u 'c:program filescommon filesmicrosoft shareddaodao360.dll'
Re-register it (as above). Open Access, and select the library reference again.
Ambiguities arise if libraries have objects with the same name. For example, the DAO and ADO libraries both have a Recordset object, so Access 2000 and 2002 often choke when a DAO recordset was intended. Any of these ideas will solve the clash:
- Remove the reference to either the ADO or the DAO library. (See below.)
- Change the priority of the DAO library, by moving it above ADO.
- Disambiguate each declaration, by specifying the library you intend, e.g.:
Dim rs As DAO.Recordset
Inconsistencies and data corruption can result from referencing the wrong library for your version of Access. For example, the DAO 3.5 library was designed for Access 97, whereas DAO 3.6 is designed for Access 2000, 2002, and 2003. Access 2007 uses the ACEDAO library to give you the new functionality in the private JET engine. Use the table below to ensure you reference the correct files for your version of Access.
December 2006 update: There is a new issue with bad references when running multiple versions of Access on Windows Vista.
What libraries do I need?
Unnecessary libraries waste memory, slow loading, increase the chance of problems, and hamper debugging. The three essentials are VBA, Access, DAO. The VBA and Access libraries are built in, and will always have highest priority. Access will not let you remove these libraries from your database.
DAO stands for Data Access Objects. It is the object model written specifically for Access, so it's no surprise that it gives the best power and performance for data stored in Access tables.
ADO stands for ActiveX Data Objects. It is a more generic library, designed to handle data from sources other than Access tables (SQL Server) and interfaces other than Access (e.g. web-based.) If you are working on these enterprise databases, you don't need an explanation of ADO here.
Cannot Load The Ole 2.0 Or Doc File Librariesor Doc File Libraries
Unfortunately, Microsoft made ADO the default library in Access 2000 and 2002. DAO is back by default in Access 2003 and 2007. Michael Kaplan illustrates why you need DAO in his blog posting, What does DAO have that ADO/ADOX/JRO do not?
Include other libraries when you have a reason to do so. For example, referencing the Microsoft Office 10.0 Object Library in Access 2002 gives you the FileDialog object so you can show the user a File Open dialog without resorting to API calls. (Note: FileDialog does not work in MDEs or the runtime version, and the msoFileDialogSaveAs option doesn't work at all.)
Which version?
This table lists the references appropriate to your version of Access, along with the file name if the reference is 'missing':
Library name | Access | Ver. | File type | Library file (default location) |
VBA (Visual Basic For Applications) | 2010 | C:Program FilesCommon FilesMicrosoft Sharedvbavba7vbe7.dll | ||
2007 | C:Program FilesCommon FilesMicrosoft Sharedvbavba6vbe6.dll | |||
2003 | ||||
2002 | ||||
2000 | ||||
97 | C:Program FilesCommon FilesMicrosoft Sharedvbavba332.dll | |||
Access (Microsoft Access xx.x Object Library) | 2010 | 14.0 | C:Program FilesMicrosoft OfficeOffice14msacc.olb | |
2007 | 12.0 | C:Program FilesMicrosoft OfficeOffice12msacc.olb | ||
2003 | 11.0 | C:Program FilesMicrosoft OfficeOffice11msacc.olb | ||
2002 | 10.0 | C:Program FilesMicrosoft OfficeOffice10msacc.olb | ||
2000 | 9.0 | C:Program FilesMicrosoft OfficeOfficemsacc9.olb | ||
97 | 8.0 | C:Program FilesMicrosoft OfficeOfficemsacc8.olb | ||
DAO (Microsoft DAO 3.x Object Library or Microsoft Office xx.x Access database engine) | 2010 | 14.0 | ACCDB | C:Program FilesCommon FilesMicrosoft SharedOffice14acedao.dll |
MDB | C:program filescommon filesmicrosoft shareddaodao360.dll | |||
2007 | 12.0 | ACCDB | C:Program FilesMicrosoft OfficeOffice12acedao.dll | |
MDB | C:program filescommon filesmicrosoft shareddaodao360.dll | |||
2003 | 3.6 | |||
2002 | ||||
2000 | ||||
97 | 3.51 | C:program filescommon filesmicrosoft shareddaodao350.dll | ||
ADODB (Microsoft ActiveX Data Objects 2.x Library) | all versions | C:Program FilesCommon FilesSystemADOmsado25.tlb |
Where can I read more?
Doug Steele has many good links in his article, Access Reference Errors.
Tom Wickerath discusses ADO and DAO Library References in Access Databases.
For Microsoft's knowledgebase article on the libraries for Access 2002, see,
ACC2002: References That You Must Set When You Work with Microsoft Access
Home | Index of tips | Top |