Reference to DAO object in VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arlan - 30 Jun 2005 18:16 GMT

I have created a small application in VBA the references the 'Microsoft DAO
3.6 Object' and it works great until I save it as a template for
distribution. When the template is loaded the reference to DAO is not
checked. Is there a feature (bug) that needs to be worked around (if so
how?) or am I missing somthing more basic?
This is written in Word 2003 and needs to operate in Word XP as well.

THANKS!

Reply to this Message

Jezebel - 01 Jul 2005 00:10 GMT

You need to distribute and install the DAO library. Users won't necessarily
have it on their computer, since MS moved to ADO.

>I have created a small application in VBA the references the 'Microsoft DAO
> 3.6 Object' and it works great until I save it as a template for
[quoted text clipped - 4 lines]
>
> THANKS!

Reply to this Message

Arlan - 01 Jul 2005 09:07 GMT

I hadn't thought of that... Thanks. BUT my testing was on the same computer
as the development computer so availability of the DAO object is not the
issue. The reference to it is lost when I save the application as a .dot
file. Is this normal? How can I prevent it?

> You need to distribute and install the DAO library. Users won't necessarily
> have it on their computer, since MS moved to ADO.
[quoted text clipped - 7 lines]
> >
> > THANKS!

Reply to this Message

Doug Robbins - 01 Jul 2005 12:21 GMT

What was the "application" before you saved it as a .dot file.

Having always started with a .dot file, I have never had the problem that
you are experiencing.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I hadn't thought of that... Thanks. BUT my testing was on the same
>computer
[quoted text clipped - 16 lines]
>> >
>> > THANKS!

Reply to this Message