From: Leslie Isaacs on
Hello All

I have a split Access2K mdb, with a backend on a server and a frontend on
each of 5 PCs. I routinely work on a 'master' version of the frontend, which
also lives on the server and which is copied to each PC when it is booted up
in the morning. The frontend includes a 3rd party add-in application, which
requires some .ini files to be in place on the local workstation, and some
references to be set. Everything works fine, except that some of the PCs
don't seem to retain these references: immediately after each boot-up these
references are either unticked, or they are ticked but annotated as MISSING.
Then they have to be re-selected, and all if fine again ... until the next
boot-up.

This behaviour seems not to be consistent, either across all the PCs or even
for a given PC - or at least I have not been able to identify any rule that
will predict when the references will be retained and when they will not.

Anyone any ideas?

Hope someone can help.

Many thanks
Leslie Isaacs


From: Douglas J. Steele on
See whether what I've got at
http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html helps you.
There are also a number of references on this topic in my December, 2003
"Access Answers" column in Pinnacle Publication's "Smart Access", although I
don't know how many of the references cited are still around. (You can
download the column and a sample database that includes hyperlinks to all of
the references for free at
http://www.accessmvp.com/DJSteele/SmartAccess.html )

A good resource for trying to automate your process is what MichKa has at
http://www.trigeminal.com/usenet/usenet026.asp

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


"Leslie Isaacs" <leslie(a)gppayroll.org.uk> wrote in message
news:eTJNTVQZKHA.736(a)TK2MSFTNGP06.phx.gbl...
> Hello All
>
> I have a split Access2K mdb, with a backend on a server and a frontend on
> each of 5 PCs. I routinely work on a 'master' version of the frontend,
> which also lives on the server and which is copied to each PC when it is
> booted up in the morning. The frontend includes a 3rd party add-in
> application, which requires some .ini files to be in place on the local
> workstation, and some references to be set. Everything works fine, except
> that some of the PCs don't seem to retain these references: immediately
> after each boot-up these references are either unticked, or they are
> ticked but annotated as MISSING. Then they have to be re-selected, and all
> if fine again ... until the next boot-up.
>
> This behaviour seems not to be consistent, either across all the PCs or
> even for a given PC - or at least I have not been able to identify any
> rule that will predict when the references will be retained and when they
> will not.
>
> Anyone any ideas?
>
> Hope someone can help.
>
> Many thanks
> Leslie Isaacs
>


From: Tony Toews [MVP] on
"Leslie Isaacs" <leslie(a)gppayroll.org.uk> wrote:

>The frontend includes a 3rd party add-in application, which
>requires some .ini files to be in place on the local workstation, and some
>references to be set. Everything works fine, except that some of the PCs
>don't seem to retain these references: immediately after each boot-up these
>references are either unticked, or they are ticked but annotated as MISSING.
>Then they have to be re-selected, and all if fine again ... until the next
>boot-up.

Run the following code and we'll give you some suggestions. Also
specifically which references are you having problems with?

Sub ViewReferenceDetails()

Dim ref As Reference

For Each ref In Access.References
Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor & "
- " & ref.FullPath
Next ref

End Sub

--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/
From: Leslie Isaacs on
Tony

Many thanks for your offer. It's Sunday here now so I'm not in the office,
but will be tomorrow and will run your code and get back to you then.

Cheers
Les

"Tony Toews [MVP]" <ttoews(a)telusplanet.net> wrote in message
news:mdcuf59ti134d0gv843davrrao2j57kc3a(a)4ax.com...
> "Leslie Isaacs" <leslie(a)gppayroll.org.uk> wrote:
>
>>The frontend includes a 3rd party add-in application, which
>>requires some .ini files to be in place on the local workstation, and some
>>references to be set. Everything works fine, except that some of the PCs
>>don't seem to retain these references: immediately after each boot-up
>>these
>>references are either unticked, or they are ticked but annotated as
>>MISSING.
>>Then they have to be re-selected, and all if fine again ... until the next
>>boot-up.
>
> Run the following code and we'll give you some suggestions. Also
> specifically which references are you having problems with?
>
> Sub ViewReferenceDetails()
>
> Dim ref As Reference
>
> For Each ref In Access.References
> Debug.Print ref.Name & " - " & ref.Major & "." & ref.Minor & "
> - " & ref.FullPath
> Next ref
>
> End Sub
>
> --
> Tony Toews, Microsoft Access MVP
> Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
> Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
> For a free, convenient utility to keep your users FEs and other files
> updated see http://www.autofeupdater.com/
> Granite Fleet Manager http://www.granitefleet.com/


From: Leslie Isaacs on
Douglas

Many thanks for your reply.

I have to say that reading everything at the references you gave did serve
to show me how little I know! I'm afraid a lot of it was beyond me - and I
couldn't even get past step 1 of MichKa's guide! I did get from it the need
to ensure that all the ini files are the same version, and in the same
location, on each PC and on the development machine - but I have already
done this.

I will try again to follow your article, and Michka's, and I also now have
some code from Tony Toews that might help. I'll report backj here tomorrow.

Thanks again
Les


"Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote in message
news:uXHbzBSZKHA.2188(a)TK2MSFTNGP04.phx.gbl...
> See whether what I've got at
> http://www.accessmvp.com/DJSteele/AccessReferenceErrors.html helps you.
> There are also a number of references on this topic in my December, 2003
> "Access Answers" column in Pinnacle Publication's "Smart Access", although
> I don't know how many of the references cited are still around. (You can
> download the column and a sample database that includes hyperlinks to all
> of the references for free at
> http://www.accessmvp.com/DJSteele/SmartAccess.html )
>
> A good resource for trying to automate your process is what MichKa has at
> http://www.trigeminal.com/usenet/usenet026.asp
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Leslie Isaacs" <leslie(a)gppayroll.org.uk> wrote in message
> news:eTJNTVQZKHA.736(a)TK2MSFTNGP06.phx.gbl...
>> Hello All
>>
>> I have a split Access2K mdb, with a backend on a server and a frontend on
>> each of 5 PCs. I routinely work on a 'master' version of the frontend,
>> which also lives on the server and which is copied to each PC when it is
>> booted up in the morning. The frontend includes a 3rd party add-in
>> application, which requires some .ini files to be in place on the local
>> workstation, and some references to be set. Everything works fine, except
>> that some of the PCs don't seem to retain these references: immediately
>> after each boot-up these references are either unticked, or they are
>> ticked but annotated as MISSING. Then they have to be re-selected, and
>> all if fine again ... until the next boot-up.
>>
>> This behaviour seems not to be consistent, either across all the PCs or
>> even for a given PC - or at least I have not been able to identify any
>> rule that will predict when the references will be retained and when they
>> will not.
>>
>> Anyone any ideas?
>>
>> Hope someone can help.
>>
>> Many thanks
>> Leslie Isaacs
>>
>
>


 |  Next  |  Last
Pages: 1 2
Prev: kk
Next: Cascading Combo in Data Access Page