[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

OLE Problem in Access97

Posted on 2000-05-18
8
Medium Priority
?
461 Views
Last Modified: 2008-03-04
I am using Access 97. When I try to see a graph created in Access, I  always get the error:

The OLE isn't registered.
To register the OLE server, re-install it.

Do you know what I have to do to fix it, without re-installing Access again?

Thank you
0
Comment
Question by:dinosaurus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 14

Expert Comment

by:mgrattan
ID: 2822261
It sounds like your charts were created using the Excel charting engine instead of the Microsoft Graph engine.
Check the references for the database:

1.  Open a module.
2.  Click Tools, References.  Look for entries that have MISSING in the description.  
3.  Remove the check mark for any entries that contain MISSING.  Close and re-open the database.
4.  Add back the reference for Microsoft Excel from the Tools, References window.
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 2822302
Another possibility is that the charts were created using the reference for Microsoft Graph.  If your References listing shows a MISSING next to Microsoft Graph 8.0 then use the steps described above to clear and reset the reference.
0
 

Author Comment

by:dinosaurus
ID: 2824837
I did the following things, but still...not fixed:

1. Re-installed Office, using its own re-install command button
2. Reloaded an older copy of the database that I am sure it worked,
3. Opened the Tools>References in the VB Editor. There were no MISSING
checkmarks (where do I see them anyway?), and there is no reference to Microsoft Graph 8.0 (MS Graph does not exist in the list, although
installed with Office).

The problem still exists. I created the graphs using the graph command of Access if I remember well. Nothing to do with Excel.

Where should I see the MISSING (although I walked through all the options and still no MISSING sign anywhere)?
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 14

Accepted Solution

by:
mgrattan earned 400 total points
ID: 2826197
If a reference were missing you would see it in the description line of the reference--for example, instead of the description reading "Microsoft Graph 8.0" it would read "MISSING: Microsoft Graph 8.0".

You don't necessarily need the reference in order to use Microsoft Graph since those charts are actually embedded as OLE objects.  The error you received usually indicates a missing reference but, in this case, it sounds like the OLE class entry in the Windows Registry has been corrupted.

You can do a complete uninstall of Office 97 making sure you manually delete the folder c:\program files\common files\microsoft shared and all of its sub-folders (unless you have other add-ins installed such as the Replication Manager; then you would leave those add-in folders alone).

In fact, you might just want to refer to the following article:

http://support.microsoft.com/support/kb/articles/Q158/6/58.ASP?LN=EN-US&SD=gn&FR=0

Once you have complete removed Office 97 according to the Knowledge Base article you should be able to re-install and the OLE classes should be properly registered.
0
 

Author Comment

by:dinosaurus
ID: 2827197
Thanks, I will give it a try and let you know. By the way, the chart appears in Design mode, but not in Browse mode...
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 2827300
That can happen!  I have, for example, been able to use the Microsoft Forms 2.0 objects in certain modes but get a registration error when I double-click it in design mode to see the properties; even though I can change the properties via code....strange, but true.
0
 

Author Comment

by:dinosaurus
ID: 2831090
Thanks for all. It works now...until the next time something goes wrong...
0
 
LVL 14

Expert Comment

by:mgrattan
ID: 2831262
Glad I could help out dinosaurus.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question