Instr function not defined--- Version conflict?

#1 (**permalink**) 28-Jul-2006, 08:42 AM

I have copied an Access file to the network. Everything looks good from my
machine. However when the user works with the database, one of the subforms
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13986-instr-function-not-defined-version-conflict.html
has no data.
I tried to even go into design view on his machine and I get a message
"Instr function no defined".... I have SP-3 and he does not. Could the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13986
version be the problem? Would I need to change the app, or would updating to
SP-3 on his machine help?... I did not think it was a version problem because
the data showed up until I made a change and re-copied it .. but the data
shows up fine on my machine

#2 (**permalink**) 28-Jul-2006, 08:42 AM

On Wed, 26 Jul 2006 11:30:02 -0700, JoeA2006 wrote:

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13986
> I have copied an Access file to the network. Everything looks good from my
> machine. However when the user works with the database, one of the subforms
> has no data.
> I tried to even go into design view on his machine and I get a message
> "Instr function no defined".... I have SP-3 and he does not. Could the
> version be the problem? Would I need to change the app, or would updating to
> SP-3 on his machine help?... I did not think it was a version problem because
> the data showed up until I made a change and re-copied it .. but the data
> shows up fine on my machine

That PC has a missing reference.
Open any module in Design view (or click Ctrl + G).
On the Tools menu, click References.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13986
Click to clear the check box for the type library or object library
marked as "Missing:."

An alternative to removing the reference is to restore the referenced
file to the path specified in the References dialog box. If the
referenced file is in a new location, clear the "Missing:" reference
and create a new reference to the file in its new folder.

See Microsoft KnowledgeBase articles:
283115 'ACC2002: References That You Must Set When You Work with
Microsoft Access'
Or for Access 97:
175484 'References to Set When Working With Microsoft Access' for
the correct ones needed,
and
160870 'VBA Functions Break in Database with Missing References' for
how to reset a missing one.

For even more information, see
http://www.accessmvp.com/djsteele/Ac...nceErrors.html
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

#3 (**permalink**) 28-Jul-2006, 08:42 AM

When I look at the references in the VBA editor, on the users machine ,it
looks like the same references are checked as are when I look at it on my
machine. Both machines are Access 2000. The references checked are Visual
Basic for Applications,Microsoft Access 9.0 Object library, OLE Automation,
Microsoft ActiveX Data objects 2.1 Library and Microsoft Windows common
controls sp6. Do I need to check some of the others. It looks like from the
information you directed me to, some of the others need to be checked. I did
not find any marked as "missing" but there were only 5 boxes checked.

"fredg" wrote:

> On Wed, 26 Jul 2006 11:30:02 -0700, JoeA2006 wrote:
>
> > I have copied an Access file to the network. Everything looks good from my
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13986
> > machine. However when the user works with the database, one of the subforms
> > has no data.
> > I tried to even go into design view on his machine and I get a message
> > "Instr function no defined".... I have SP-3 and he does not. Could the
> > version be the problem? Would I need to change the app, or would updating to
> > SP-3 on his machine help?... I did not think it was a version problem because
> > the data showed up until I made a change and re-copied it .. but the data
> > shows up fine on my machine
>
> That PC has a missing reference.
> Open any module in Design view (or click Ctrl + G).
> On the Tools menu, click References.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13986
> Click to clear the check box for the type library or object library
> marked as "Missing:."
>
> An alternative to removing the reference is to restore the referenced
> file to the path specified in the References dialog box. If the
> referenced file is in a new location, clear the "Missing:" reference
> and create a new reference to the file in its new folder.
>
> See Microsoft KnowledgeBase articles:
> 283115 'ACC2002: References That You Must Set When You Work with
> Microsoft Access'
> Or for Access 97:
> 175484 'References to Set When Working With Microsoft Access' for
> the correct ones needed,
> and
> 160870 'VBA Functions Break in Database with Missing References' for
> how to reset a missing one.
>
> For even more information, see
> http://www.accessmvp.com/djsteele/Ac...nceErrors.html
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail
>

#4 (**permalink**) 28-Jul-2006, 08:42 AM

It is vital that everybody that uses the same front-end have the Same
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13986
Service Packs, due to this kind of stuff & to prevent it if distributed

Pieter

"fredg" wrote in message
news:ncm4fss32am0.146b9b9scxohs.dlg@40tude.net...
> On Wed, 26 Jul 2006 11:30:02 -0700, JoeA2006 wrote:
>
>> I have copied an Access file to the network. Everything looks good from
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13986
>> my
>> machine. However when the user works with the database, one of the
>> subforms
>> has no data.
>> I tried to even go into design view on his machine and I get a message
>> "Instr function no defined".... I have SP-3 and he does not. Could the
>> version be the problem? Would I need to change the app, or would updating
>> to
>> SP-3 on his machine help?... I did not think it was a version problem
>> because
>> the data showed up until I made a change and re-copied it .. but the data
>> shows up fine on my machine
>
> That PC has a missing reference.
> Open any module in Design view (or click Ctrl + G).
> On the Tools menu, click References.
> Click to clear the check box for the type library or object library
> marked as "Missing:."
>
> An alternative to removing the reference is to restore the referenced
> file to the path specified in the References dialog box. If the
> referenced file is in a new location, clear the "Missing:" reference
> and create a new reference to the file in its new folder.
>
> See Microsoft KnowledgeBase articles:
> 283115 'ACC2002: References That You Must Set When You Work with
> Microsoft Access'
> Or for Access 97:
> 175484 'References to Set When Working With Microsoft Access' for
> the correct ones needed,
> and
> 160870 'VBA Functions Break in Database with Missing References' for
> how to reset a missing one.
>
> For even more information, see
> http://www.accessmvp.com/djsteele/Ac...nceErrors.html
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail

#5 (**permalink**) 28-Jul-2006, 08:42 AM

It is vital that everybody that uses the same front-end have the Same
Service Packs, due to this kind of stuff & to prevent it if distributed

Pieter

"fredg" wrote in message
news:ncm4fss32am0.146b9b9scxohs.dlg@40tude.net...
> On Wed, 26 Jul 2006 11:30:02 -0700, JoeA2006 wrote:
>
>> I have copied an Access file to the network. Everything looks good from
>> my
>> machine. However when the user works with the database, one of the
>> subforms
>> has no data.
>> I tried to even go into design view on his machine and I get a message
>> "Instr function no defined".... I have SP-3 and he does not. Could the
>> version be the problem? Would I need to change the app, or would updating
>> to
>> SP-3 on his machine help?... I did not think it was a version problem
>> because
>> the data showed up until I made a change and re-copied it .. but the data
>> shows up fine on my machine
>
> That PC has a missing reference.
> Open any module in Design view (or click Ctrl + G).
> On the Tools menu, click References.
> Click to clear the check box for the type library or object library
> marked as "Missing:."
>
> An alternative to removing the reference is to restore the referenced
> file to the path specified in the References dialog box. If the
> referenced file is in a new location, clear the "Missing:" reference
> and create a new reference to the file in its new folder.
>
> See Microsoft KnowledgeBase articles:
> 283115 'ACC2002: References That You Must Set When You Work with
> Microsoft Access'
> Or for Access 97:
> 175484 'References to Set When Working With Microsoft Access' for
> the correct ones needed,
> and
> 160870 'VBA Functions Break in Database with Missing References' for
> how to reset a missing one.
>
> For even more information, see
> http://www.accessmvp.com/djsteele/Ac...nceErrors.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13986
> --
> Fred
> Please respond only to this newsgroup.
> I do not reply to personal e-mail

Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13986

--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4367 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len

#6 (**permalink**) 28-Jul-2006, 08:42 AM

I opened the Access file up on another users computer that has the same
Access version I have and the data for that one subform does not show up, but
I still see it from my machine. Do I need to rebuild the query and copy over
the old version? I am running out of ideas as to how to solve this. Thanks

"Pieter Wijnen" wrote:

> It is vital that everybody that uses the same front-end have the Same
> Service Packs, due to this kind of stuff & to prevent it if distributed
>
> Pieter
>
>
>
> "fredg" wrote in message
> news:ncm4fss32am0.146b9b9scxohs.dlg@40tude.net...
> > On Wed, 26 Jul 2006 11:30:02 -0700, JoeA2006 wrote:
> >
> >> I have copied an Access file to the network. Everything looks good from
> >> my
> >> machine. However when the user works with the database, one of the
> >> subforms
> >> has no data.
> >> I tried to even go into design view on his machine and I get a message
> >> "Instr function no defined".... I have SP-3 and he does not. Could the
> >> version be the problem? Would I need to change the app, or would updating
> >> to
> >> SP-3 on his machine help?... I did not think it was a version problem
> >> because
> >> the data showed up until I made a change and re-copied it .. but the data
> >> shows up fine on my machine
> >
> > That PC has a missing reference.
> > Open any module in Design view (or click Ctrl + G).
> > On the Tools menu, click References.
> > Click to clear the check box for the type library or object library
> > marked as "Missing:."
> >
> > An alternative to removing the reference is to restore the referenced
> > file to the path specified in the References dialog box. If the
> > referenced file is in a new location, clear the "Missing:" reference
> > and create a new reference to the file in its new folder.
> >
> > See Microsoft KnowledgeBase articles:
> > 283115 'ACC2002: References That You Must Set When You Work with
> > Microsoft Access'
> > Or for Access 97:
> > 175484 'References to Set When Working With Microsoft Access' for
> > the correct ones needed,
> > and
> > 160870 'VBA Functions Break in Database with Missing References' for
> > how to reset a missing one.
> >
> > For even more information, see
> > http://www.accessmvp.com/djsteele/Ac...nceErrors.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13986
> > --
> > Fred
> > Please respond only to this newsgroup.
> > I do not reply to personal e-mail
>
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13986
>

#7 (**permalink**) 28-Jul-2006, 08:42 AM

You can always try opening it with the /Decompile switch to get rid of all
compiled code before putting it on the net

shortcut: Decompile
Target: /DECOMPILE

HTH

Pieter

"JoeA2006" wrote in message
news:9BCDB8EB-B616-42EF-853A-CA4DDB87A2F6@microsoft.com...
>I opened the Access file up on another users computer that has the same
> Access version I have and the data for that one subform does not show up,
> but
> I still see it from my machine. Do I need to rebuild the query and copy
> over
> the old version? I am running out of ideas as to how to solve this. Thanks
>
> "Pieter Wijnen" wrote:
>
>> It is vital that everybody that uses the same front-end have the Same
>> Service Packs, due to this kind of stuff & to prevent it if distributed
>>
>> Pieter
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13986
>>
>>
>>
>> "fredg" wrote in message
>> news:ncm4fss32am0.146b9b9scxohs.dlg@40tude.net...
>> > On Wed, 26 Jul 2006 11:30:02 -0700, JoeA2006 wrote:
>> >
>> >> I have copied an Access file to the network. Everything looks good
>> >> from
>> >> my
>> >> machine. However when the user works with the database, one of the
>> >> subforms
>> >> has no data.
>> >> I tried to even go into design view on his machine and I get a
>> >> message
>> >> "Instr function no defined".... I have SP-3 and he does not. Could the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13986
>> >> version be the problem? Would I need to change the app, or would
>> >> updating
>> >> to
>> >> SP-3 on his machine help?... I did not think it was a version problem
>> >> because
>> >> the data showed up until I made a change and re-copied it .. but the
>> >> data
>> >> shows up fine on my machine
>> >
>> > That PC has a missing reference.
>> > Open any module in Design view (or click Ctrl + G).
>> > On the Tools menu, click References.
>> > Click to clear the check box for the type library or object library
>> > marked as "Missing:."
>> >
>> > An alternative to removing the reference is to restore the referenced
>> > file to the path specified in the References dialog box. If the
>> > referenced file is in a new location, clear the "Missing:" reference
>> > and create a new reference to the file in its new folder.
>> >
>> > See Microsoft KnowledgeBase articles:
>> > 283115 'ACC2002: References That You Must Set When You Work with
>> > Microsoft Access'
>> > Or for Access 97:
>> > 175484 'References to Set When Working With Microsoft Access' for
>> > the correct ones needed,
>> > and
>> > 160870 'VBA Functions Break in Database with Missing References' for
>> > how to reset a missing one.
>> >
>> > For even more information, see
>> > http://www.accessmvp.com/djsteele/Ac...nceErrors.html
>> > --
>> > Fred
>> > Please respond only to this newsgroup.
>> > I do not reply to personal e-mail
>>
>>
>>

--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 4367 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len