Function not available

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Derek Brown - 12 Apr 2005 00:35 GMT

Hi all

I left a copy of this question on the accessforms newsgroup before I found
this developer site. Sorry. Here's the question anyway

I have an MDE file that works perfectly when I copy it to a CD and run it
from CD but when I package it up with the developer wizard and then install
it on another computer I get "Function not available" in one of the queries.
Why? Help!!

Reply to this Message

Alex Dybenko - 12 Apr 2005 08:39 GMT

Look at menu tools-refernces and check that you install all optional activex
controls or DLLs on other PC. if you have refenrence to
word/excel/outlook/etc - other PC should have same version, else you have to
use late bindings
if you are not sure whatg is optional - list all your shecked references
here

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Hi all
>
[quoted text clipped - 5 lines]
> install it on another computer I get "Function not available" in one of
> the queries. Why? Help!!

Reply to this Message

Derek Brown - 12 Apr 2005 16:46 GMT

Hi

I have the following activex controls included in the database:

VB for Aplications
MS Access 10.0 object library
OLE Automation
MS ActiveX data object 2.1 library
MS DAO 3.6 Object library

Quite honestly I have little idea what any of these files do, so I do not
know even if I need them.
I package as an MDE file so I cannot check if they are included in the
runtime version. Also for some reason MS Office XP Web components keeps
appearing in the referances why is this. I have to keep removing it.

> Look at menu tools-refernces and check that you install all optional
> activex controls or DLLs on other PC. if you have refenrence to
[quoted text clipped - 11 lines]
>> install it on another computer I get "Function not available" in one of
>> the queries. Why? Help!!

Reply to this Message

Pat Hartman - 12 Apr 2005 21:18 GMT

If you can install an .mdb on the PC with the problem it will be easier to
resolve the references. The most likely culprit though is DAO 3.6. I think
it is not installed automatically with A2K.

> Hi
>
[quoted text clipped - 27 lines]
> >> install it on another computer I get "Function not available" in one of
> >> the queries. Why? Help!!

Reply to this Message

Derek Brown - 12 Apr 2005 23:19 GMT

Sincere thanks to you all.

It appears that for some reason when MS Web Components are in the referance
list (although I have no reason to use them, but it keeps appearing in the
list and I keep removing it) the error Happens when I remove it like magic
no errors. If someone can explain that I will dance naked down my street
singing access newsgroups forever!!

Once again cheers!!

> If you can install an .mdb on the PC with the problem it will be easier to
> resolve the references. The most likely culprit though is DAO 3.6. I
[quoted text clipped - 36 lines]
>> >> of
>> >> the queries. Why? Help!!

Reply to this Message

Chris Mills - 13 Apr 2005 05:58 GMT

Get rid of all unnecessary references. Take a copy of your mdb, remove each
reference in turn, and see if it compiles. Compiles = reference unnecessary!

"OLE Automation" is certainly not required (even for OLE Automation! though
seldom does any harm). MS-Access just sticks some default references in for
good measure.

If you refer to "MS ActiveX data object 2.1 library" being the problem, find
out the filename and it must not be being distributed or installed correctly.
However, best just get rid of it.

On very rare occasions, it may be necessary to re-register DAO e.g.
regsvr32.exe <path>DAO360.dll
Since DAO is not the default for Access2002 (or A2k), either you altered the
reference list yourself, or it may have been done automatically if converted
from earlier version.

If any reference in the list is missing, the whole compile-thing throws a
wobbly (so to speak) and the error message could be anything, but that would
be a typical one.

Now, can you get your wife or daughter to deputise for you... ;-)

Chris

> Sincere thanks to you all.
>
[quoted text clipped - 5 lines]
>
> Once again cheers!!

Reply to this Message

Derek Brown - 20 May 2005 22:57 GMT

Hi Chris

Been on hols, had enough dancing naked but thanks for your reply. Most
appreciated

> Get rid of all unnecessary references. Take a copy of your mdb, remove
> each
[quoted text clipped - 42 lines]
>>
>> Once again cheers!!

Reply to this Message