Automatically Change Reference Path.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

SteveTyco - 17 Dec 2004 13:47 GMT

I have a database that uses references to excel. The users that will be
using this database have different versions of excel. Therefore, we get the
broken link all the time. How do I correct this.
Thanks.

Reply to this Message

Douglas J. Steele - 17 Dec 2004 15:32 GMT

You could try using Late Binding, which frees you from having to set a
reference to Excel in your application.

Tony Toews has some examples at
http://www.granite.ab.ca/access/latebinding.htm

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I have a database that uses references to excel. The users that will be
> using this database have different versions of excel. Therefore, we get the
> broken link all the time. How do I correct this.
> Thanks.

Reply to this Message

SteveTyco - 17 Dec 2004 17:45 GMT

Thanks. Got it. Works fine now.

> You could try using Late Binding, which frees you from having to set a
> reference to Excel in your application.
[quoted text clipped - 7 lines]
> > broken link all the time. How do I correct this.
> > Thanks.

Reply to this Message