References are not working across computers
in [Forms]
|
From: Douglas J. Steele on 6 Apr 2010 11:20 Sounds as though you've got multiple users for the same database. The proper way is to split the application into a front-end (containing the queries, forms, reports, macros and modules), linked to a back-end (containing the tables). Each user should have his/her own copy of the front-end on his/her hard drive. Then once you've repaired the references, you should have no problems. -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/DJSteele (no e-mails, please!) "JordanN" <none(a)here.com> wrote in message news:e6UjCeZ1KHA.348(a)TK2MSFTNGP02.phx.gbl... >I need it because I we have a lot of information that needs to be extracted >into a spreadsheet view to sort and examined, however extracting and >dumping into Excel and toggling back and forth between the app can be >tedious. It is the best control for the purpose. > > The problem I am facing is after installing MS KB947319, which is a OWC > patch, the MDB file will not work on a lot of the computers even though > they have the update installed. > > Half the machines took the update fine, while the other half need to have > the MDB file opened and the OWC11 component re-referenced manually because > the scripts to automatically refresh the references don't see any problem > and don't re-reference properly. Once I manually re-reference the control > on a problem computer all of the other problem computers fall in line, but > then the ones that were working before now fail. > > > "Tony Toews [MVP]" <ttoews(a)telusplanet.net> wrote in message > news:148lr5pi82svgi7omgfmp8s0sklcfbm4s5(a)4ax.com... >> "JordanN" <none(a)here.com> wrote: >> >>>I have developed a custom MDB file in Access 2003 that uses a few >>>controls >>>like: >>> >>>OWC11.DLL >>>ComCTL32.OCX >>>MSCOMCTL.OCX >>>MSCOMCT2.OCX >>>and so on. >> >> <snip> >> >>>Now I could just force these controls into the System32 folder and change >>>my >>>references to have everything point there but then I am sure I am going >>>to >>>have more issue in the future because of controls in other folders >>>getting >>>properly updated while these controls are not updated. What do I need to >>>do >>>so my project uses the control that is in the proper location? >> >> How about removing those controls? Do you really need them? Why do >> you need OWC? Note that as of Office 2007 it's been discontinued. >> >> How do you get rid of troublesome ActiveX Controls/references? >> http://www.granite.ab.ca/access/referencetroubles.htm >> >> Calendar control - See the Calendar Tips page at my website >> http://www.granite.ab.ca/access/calendars.htm >> >> Also run the following code for a complete list and we'll give you >> some suggestions. >> >> 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 >> -- >> 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 convenient utility to keep your users FEs and other files >> updated see http://www.autofeupdater.com/ >> Granite Fleet Manager http://www.granitefleet.com/ > |