DB Program dosen't work on another machine.

[Guest]

I have written a database program in MS Access 2002 format the works
perfectly on my machine. When I try to run it on the "Users" machine (same
Access version), it reports that certain (and serveral different) user
defined functions are not recognizable. I compared the library set-ups on
the two machines and they are identical except that in priority and libraries:

1. My machine uses Microsoft DAO 3.51 (and works) and
2. The other machine uses Microsoft DAO 3.6 (and doesn't work)

I tried to find and select 3.51 on the non-working machine and it was not
available to select.

What could be the problem?

Thanks

Ross

 

[Arvin Meyer [MVP]]

The DAO version you should have on your machine is DAO360.dll located in:

C:\Program Files\Common Files\Microsoft Shared\DAO

The problem is not with his version, but yours. You need you set the
reference to DAO3.6. You probably upgraded from a previous version and have
both versions on your machine.