OLE Server not registered

[W. Collier]

I'm trying to use the Chart Wizard in Access 97, but I keep getting an error
msg "OLE server is not registered - to register it, reinstall it". Am I
correct in assuming that this msg refers to the "graph8.olb"? If so, it is
already installed. I did have to register graph8.olb, but this has made no
difference (yes, it is checked). I'm able to use Microsoft Graph in Excel,
but not in Access 97. This is my first time using Microsoft Graph in Access,
so I have no history to report.

Nothing on Microsoft's database seems to refer to this problem. There is one
reference to this msg, but it is for MS Office Developer, which I don't
have.

Am I really off base here?

Thanks in advance for any help,
Wanda

[bob...@postoffice.pacbell.net]

graph8.olb is the type library. graph8.exe is what has to be registered. Run regedit and do a find on graph8. If it's registered then you should find a LocalServer32 entry that gives the path. I don't know how to register it but if you do a search(url below) on graph8 or Chart you might find out what the problem is. Bobby

http://msdn.microsoft.com/library/default.asp

[W. Collier]

Hi Bobby:

Well I'll be damned!!!  Thanks for the tip. I thought "what the heck, I'll search the registry editor" even though the MS Graph is referenced through the module. Turns out it isn't registered. How can that be? Anyone know what the difference is between registering and referencing? Why can I reference the  Object even though it's not registered thru the REGEDIT? That seems odd to me.

 

Microsoft Graph should be referenced by opening a New Module, then by selecting TOOLS, REFERENCES. Select the Object and click OK. It should be no different than registering Word, Excel etc. These are all registered and I have no problems with them except for Microsoft Graph.  Is it because this object cannot be accessed by itself?

 

I just reinstalled Office97 again, and still the same thing. I've seen a reference to manually registering an OLE server, but it was referencing Visual FoxPro (Q156547). Anyone know if this could work the same way for MS  Graph? I've looked through the KB and MSDN and found nothing directly related.

 

Any help appreciated

Wanda

<bob...@postoffice.pacbell.net> wrote in message news:398A105F...@postoffice.pacbell.net...

[bob...@postoffice.pacbell.net]

When you set a reference, it is directing Access to a type library which

contains details on which collections, methods, and properties are
available.

When you register a program a lot of entries are entered into the
registry. One of the entries points to the typelib. This entry is used
by access to display the references dialog so it seems that graph has
been registered, but something has messed it up.

Access can use the type library to load the actual program (which may be
a
DLL or EXE) and make calls to the program. When the new operator is
used, for example:

Dim app As Excel.Application
Set app = New Excel.Application

then Access uses the type library to get the class id (a unique number
which identifies the program) and uses a COM routine to load the
program. COM uses the localserver32 keyword to load the program so that
is one thing to check for accuracy.

Another method to use a program is to use CreateObject, for example
dim obj as object
set obj = CreateObject("Excel.Application")

In this case the registry is used to get the progID which points to the
class id. So another thing to check is the progID, i.e., look for
Graph8.Application I believe.

I don't know which technique the Chart Wizard uses. I use Excel because
it has more options.

I don't how to register Graph. regsvr32 is used to register DLL's
but Graph is an exe. Usually you run a program with a parameter to
register it, but I don't know what the parameter is for Graph. It's also
possible that it is registered manually using a .reg file.

Formatting your hard disk and reinstalling everything is a good way to
clean up the registry. You've probably already thought of that already,
huh? Bobby

"W. Collier" wrote:

> Hi Bobby:Well I'll be damned!!! Thanks for the tip. I thought "what
> the heck, I'll search the registry editor" even though the MS Graph is
> referenced through the module. Turns out it isn't registered. How can
> that be? Anyone know what the difference is between registering and
> referencing? Why can I reference the Object even though it's not
> registered thru the REGEDIT? That seems odd to me. Microsoft Graph
> should be referenced by opening a New Module, then by selecting TOOLS,
> REFERENCES. Select the Object and click OK. It should be no different
> than registering Word, Excel etc. These are all registered and I have
> no problems with them except for Microsoft Graph. Is it because this
> object cannot be accessed by itself? I just reinstalled Office97
> again, and still the same thing. I've seen a reference to manually
> registering an OLE server, but it was referencing Visual FoxPro
> (Q156547). Anyone know if this could work the same way for MS Graph?
> I've looked through the KB and MSDN and found nothing directly
> related. Any help appreciatedWanda
>
> <bob...@postoffice.pacbell.net> wrote in message

> news:398A105F...@postoffice.pacbell.net...graph8.olb is

[Simon Lewis]

Hi Wanda,

Graph seems to lose its registration info on a fairly regular basis in my
experience, not sure why. You can re-register it by clicking Start, Run,
then entering
"C:\Program Files\Microsoft Office\Office\graph8.exe" /regserver
in the box (adjust the path if necessary, of course).

[BTW, if you've come across article Q190735 in the KB, ignore it: you _can_
use early bound code with Graph.]

Simon Lewis

"W. Collier" <nocoll...@home.com> wrote in message
news:OseZIgi$$GA.280@cppssbbsa04...

[W. Collier]

Hi Simon:

Thanks for the tip - I'll store it away. Long story, but I ended up
having
to re-format my hard drive. I think this is what happened:

Installed Office2000 last Feb but had to uninstall it because there is
no
FoxPro ISAM driver supported. Had to reformat my hard drive.
Re-installed
Office97 but couldn't re-install Outlook 98 because it required the
download
location which no longer existed. When I checked the KB, MS gave
directions
for installing Office2000 on your system with OFF97 (although they did
not
recommend it). So, I custom-installed Outlook 2000 only, no other
files.
This configuration worked fine for 2 months until I tried using the
Graph
feature from Access97. Even though I did a custom install for only
Outlook2000 files, it must have installed MS Graph as well, causing
some confusion.
Anyway, I took out all the Office 97 & 2000 registry files &
re-installed OFF97.
Had it working ok, but then the uninstaller started acting up awhile
later & I couldn't
remove Office 97. So.... reformat. MS Update now has a download for
Outlook 98,
so I'm back to my OFF97 configuration.

Everything's working fine now, but if it loses its registration again,
I'll
know what to do.

Thanks,
Wanda

Simon Lewis <simon...@technologist.com> wrote in message
news:uHXeXi7$$GA.57@cppssbbsa04...

> Hi Wanda,
>
> Graph seems to lose its registration info on a fairly regular basis
in my
> experience, not sure why. You can re-register it by clicking Start,
Run,
> then entering
> "C:\Program Files\Microsoft Office\Office\graph8.exe" /regserver
> in the box (adjust the path if necessary, of course).
>
> [BTW, if you've come across article Q190735 in the KB, ignore it:
you _can_
> use early bound code with Graph.]
>
> Simon Lewis
>
>
> "W. Collier" <nocoll...@home.com> wrote in message
> news:OseZIgi$$GA.280@cppssbbsa04...