References
in [General]
|
Prev: kk
Next: Cascading Combo in Data Access Page
From: Leslie Isaacs on 14 Nov 2009 03:34 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 14 Nov 2009 06:48 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 14 Nov 2009 17:41 "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 15 Nov 2009 06:55 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 15 Nov 2009 07:09
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 >> > > |