Re: Access Runtime on PC without MS Office


"Rick in NS" <rbutler@xxxxxxxxxxxxxxxx(donotspam)> wrote in message
news:863C896D-556E-49E9-B30A-5F1ECBAC1E20@xxxxxxxxxxxxxxxx
I am using Microsoft Office 2003 and Visual Studio 2005 with Access Developer
Extentions to package an application for deployment. My understanding is the
the application should run on another machine using the runtime version
included in the package. However; I am testing the application on a clean
machine which does not have any copy of MS Office on it. The application
runs most routines uneventfully. However; certain forms displays and reports
based on queries fail with "Function is not available in expressions in query
express ....."

I have found references from Douglas Steele, MVP and Ken Snell, MVP that
indicate this has to do with missing references to files with an explanation
on how to check the target machine for these missing reference.

However; the target machine does not have anything on it but the runtime
version of Access and the application front-end is in MDE format. So, it is
not possible to open a code module or the debug window to check the reference
on the target machine.

Any suggestions on how to deal with this thorny issue?

On your PC open a new blank file and then check the references. These are the
default references for an Access app in Access 2003. Then compare that to the
references in the file you are having problems with. Are there any additional
references?

If there are the solution is to remove them. No app that you intend to
distribute to multiple PCs should have anything but the default references in it
or you will have no end to these headaches.

If you need to use external libraries (Outlook , Word, etc.), then use late
binding so that you don't have to set references.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Relevant Pages

  • Re: Distributed Access references
    ... > understand from trying to package an app and working w/ ... > excel to be run from my app. ... ***If Excel is installed on the target machines, then there is no need to ... application's references in locations other than what my references have ...
    (microsoft.public.access.devtoolkits)
  • Re: OSD ZTI installation cd "path not found" error
    ... Interesting....I've previously removed the image package and created a new ... Or there other references which may contain old package ID references? ... "Johan Arwidmark" wrote: ...
    (microsoft.public.sms.tools)
  • Re: Problem with natbib and crossref
    ... Some packages contain .tex files as part of their distribution, and if you use the same name as one of those files then LaTeX might not be able to find the package file it needs. ... I also see nothing in my plainnat.bst that indicates a comma should be placed after "In". ... you can run BibTeX with the --min-crossrefs switch to combine your references so that you'll have two complete references instead of two references that refer to a third. ...
    (comp.text.tex)
  • RE: Package Wizard - Installation and registration of components
    ... I have a full version of Visual Studio .NET, which presumably should package ... Just the stuff that the PDW is supposed to do. ... > references and including them in the package (which in the 2000 version was ... > which aren't necessary from the install package makes sense. ...
    (microsoft.public.access.developers.toolkitode)
  • Re: CTAN package update: biblatex 0.4
    ... may browse the package via the catalogue entry: ... It redesigns the way in which LaTeX interacts with BibTeX ... Added command \addhighpenspace ... With 172 entries, nothing get output for the references, and I get ...
    (comp.text.tex)
Loading