Those that know me know that I cannot let something get in the best way of shifting to new applied sciences reminiscent of Workplace 2010, Home windows 7, IE9 and so forth. Not even a “business critical” Entry 97 Utility. After all there are virtualization methods to get round this however for me…properly these are a final resort to take care of compatibility. Ideally I need no vestige of IE6, Home windows XP, Entry 97 and so forth in my setting, virtualized or not.

So the very first thing once I load this database I get this error: “Your Microsoft Entry database or venture accommodates a lacking or damaged reference to the file ‘dao2535.tlb’ model 3.5

In reality i acquired it virtually over 100 occasions it appeared. I held down the enter key and it flash by quickly every time ‘searching for referenced file…’ There didn’t appear to be anyway to cease this, even holding down Shift when opening the DB to open in design mode I acquired the identical factor.

 

Finally it loaded after I risked repetitive stress harm from continuous hitting ENTER. Then it broke into the debugger:

 

 

I clicked the “Stop” button to cease execution. A desk is created known as “Conversion Errors” with particulars of all the issues:

I used Alt+F11 to return to VBA Editor after which clicked Instruments –> References. I deselected the Microsoft DAO 2.5/3.51 Compatibility Library.

 

After all this library is the one which defines Recordset so what can I try this I eliminated it? Go discover the previous DAO 2.5/3.51 library? I didn’t have the file available. So I attempted including this:

In order that removed the  “User-Defined type not defined”. This time I acquired a brand new error:

 

Adopted by

Adopted by

The database is tough coded to load knowledge from the precise location and I used to be testing on an remoted machine. So to check it I used SUBST command to simulate the P: drive

 

This not less than acquired me now to a launch display screen, however extra errors

 

This time I opened up the DB in design mode by holding SHIFT down whereas launching the file then hit ALT+F11 to deliver into VBA Editor. From the VBA menu I hit Debug –> Compile. This confirmed the user-defined sort “database” as not acknowledged, so added the next library:

See also  LogoSmartz Logo Maker v11.0.0 Cracked

 

OK so now once I compile I’m not getting any unknown references. However I get error:

 

 

Nicely it is because the renamed the management to a pleasant title with out updating the code. It has been modified from Combo37 to Project_Task_Number. In all probability by no means observed this since you don’t see these errors until you compile the DB. I can’t bear in mind far sufficient again if Entry 97 had a compile choice…

So then I discovered much more form of errors like this, stuff simply from not compiling, leaving previous code round and so forth after kinds had modified. These wouldn’t have affected software execution these as these bits of code by no means acquired executed. Then presto:

I used to be getting someplace now!

I hit Ctrl+Break after which selected Debug to seek out out the place this question was. I acquired it added myself to the desk…and

YAY! Utility is UP! Examined the features, they usually’re all working no errors!

I did additionally wish to substitute all of the fonts from “Time Romans” to “Segoe UI” to make it look rather less Home windows 3.1 like and a bit extra  WPF-like however with 100+ kinds and I couldn’t see any Search & Substitute choices for Font names I simply left it as is.

Microsoft additionally has a variety of instruments that will assist with this course of together with:

Entry 2.0 Converter for Entry 2003

should you’re unlucky to have Win3.1 and Entry 2.0 nonetheless working…

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=91C944F8-F3AB-41E9-902A-2255A66E1C4A

Entry 2003 Conversion Toolkit

To help in migrating previous databases from Entry 97 to Entry 2003 format

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=2E861E76-5D89-450A-B977-980A9841111E&displaylang=en

Migrating from Entry 2003 to Entry 2010

http://office.microsoft.com/en-us/access-help/migrating-to-access-2010-from-access-2003-HA101886851.aspx

Workplace 2010 Instrument: Workplace Atmosphere Evaluation Instrument

Accessible from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=ea33f615-188d-464e-bc64-3ab06aa43961&displaylang=en

  • Presently put in purposes and set up setting.
    • Add-ins presently in use by Workplace shoppers.
    • Packages that aren’t registered as add-ins however nonetheless work together with Workplace packages.
    • Report: Environmental evaluation (potential improve points).
    • Report: Add-ins evaluation—record of third occasion packages and details about the compatibility of these packages with Microsoft Workplace 2010.
    • Supported Working Programs: Home windows 7;Home windows Server 2003;Home windows Server 2008;Home windows Vista;Home windows XP Service Pack 2
  • This software collects data for the next Workplace purposes:
    • Microsoft Workplace 97
    • Microsoft Workplace 2000
    • Microsoft Workplace XP
    • Microsoft Workplace 2003
    • 2007 Microsoft Workplace system
    • Microsoft Workplace 2010
  • As well as, you should have the next put in:
    • Microsoft .NET Framework 2.0
    • Microsoft Workplace Excel 2007 or Microsoft Excel 2010
See also  Pixologic ZBrush 4R8 Free Download

Microsoft Workplace Code Compatibility Inspector

Accessible from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=23c8a7f6-88b3-48ef-9710-9742340562c0&displaylang=en

The Microsoft Workplace Code Compatibility Inspector for is designed to assist an enterprise or small enterprise replace Visible Primary for Functions (VBA) and Visible Studio Instruments for Workplace code in order that it’s appropriate with Workplace 2010. The Inspector doesn’t appropriate code; it inspects code, after which feedback particular strains of code that reference objects within the object mannequin which have modified ultimately or have been deprecated. (In VBA code, the software additionally feedback Declare statements for 64-bit compatibility.) You possibly can then modify the code primarily based on the feedback, or use the hyperlinks which are offered within the feedback to view subjects on the Net which are pertinent to a specific line of your code.

Once more, it’s as much as you to switch the code should you decide that it must be modified.

The important thing options of the Workplace Code Compatibility Inspector embody the next:

  • It consists of 4 add-ins that load, one add-in per software, in Excel 2010, PowerPoint 2010, Phrase 2010, and Visible Studio 2008.
  • It runs on a per-user or a per-document foundation. For VBA, customers open a doc and run the software from the Developer tab. For Visible Studio tasks, the developer runs the software from the Instruments menu.
  • It scans the tasks within the present doc or Visible Studio Answer through the use of a easy textual content search, on the lookout for parentObject.Property mixtures, and scans Declare statements for 64-bit compatibility (in VBA).
  • It provides feedback within the code the place it finds different potential points.
  • It shows a abstract and an in depth report of its findings after it completes its inspection.

You can’t use this software to examine code from Microsoft Outlook or Microsoft Entry. Nonetheless, you should use the software to examine Excel, PowerPoint, and Phrase code for interplay with the Outlook object mannequin.

See also  PeerBlock Alternative: 7 Best Options [Other IP Blockers and VPNs]

Workplace 2010 MIgration Planning Supervisor

Accessible from http://www.microsoft.com/downloads/en/details.aspx?FamilyID=81D208F0-7ACE-499C-8975-728C648B8B43

This toolset consists of the OMPM File Scanner (Offscan.exe), a command-line software that scans recordsdata for conversion points and shops the ends in XML log recordsdata in a configurable location and, optionally, can bundle these log recordsdata into .cab recordsdata. The OMPM File Scanner performs two sorts of scans:

  • A lightweight scan that rapidly identifies the Workplace paperwork on a consumer’s pc or community file system.
  • A deep scan you can carry out on Workplace paperwork to crawl doc properties that present indicators of potential conversion points.
  • A macro scan that rapidly identifies the depend of potential points in VBA code included in doc macros, or from 64-bit Workplace 2010 adjustments. Macro scanning is on the market just for Microsoft Excel, PowerPoint, and Phrase recordsdata.

Essential:

As well as it supplies the next parts:

  • A set of utilities that you should use to import the XML log recordsdata which are generated by the OMPM File Scanner into a number of Microsoft SQL Server 2000, Microsoft SQL Server 2005, or Microsoft SQL Server 2005 Categorical Version, Microsoft SQL Server 2008, Microsoft SQL Server 2008 Categorical Version, Microsoft SQL Server 2008 R2, or Microsoft SQL Server 2008 R2 Categorical Version databases.
  • A Microsoft Entry 2010–primarily based reporting answer that gives totally different experiences in your evaluation and lets you outline file units for automated processing.
  • The Workplace File Converter (OFC), which helps you to do bulk conversions of particular Workplace recordsdata which are in model 97 by 2003 codecs to the Workplace 2010 file codecs.
  • The Model Extraction Instrument (VET), which helps you to extract a number of saved variations of a single Phrase 97–2003 doc to individualfiles in Phrase 2010.

 

If you’re utilizing 64-bits of Workplace: http://technet.microsoft.com/en-us/library/ee681792.aspx

Leave a Reply

Your email address will not be published.