Excel obj referenece keeps going missing !!

[Elfman]

Hi all,

I'm having a bit of trouble with references. Several databases on my local network have begun to continually have trouble with he excel object reference.

Whenever one of these databases s started up I have to go to debug menu to refresh eh reference.

Can any tell me why this is and how i would go about fixing it?

I'm using access 97 and the version of the Excel object is 9


- Thanks in advance

-Elfman

 

[DJkarl]

Hi all,

I'm having a bit of trouble with references. Several databases on my local network have begun to continually have trouble with he excel object reference.

Whenever one of these databases s started up I have to go to debug menu to refresh eh reference.

Can any tell me why this is and how i would go about fixing it?

I'm using access 97 and the version of the Excel object is 9


- Thanks in advance

-Elfman

If anyone who uses this database has a more recent version of Excel installed on their machine it will update the reference to the new version and all the old users will be left with an error message when they try to use it.

 

[boblarson]

So what you can do is do move to late binding instead of early binding in your code so that you need not even set the reference.