Re: Refreshing Referenced Module

the front end is probably the best way, but hard to enforce as the app
runs in three plants. (3 Bosses and close to 50 users to convince) -
they are not used to tight version control although the original author
(he is one of the bosses) constantly potters with the frontend.

They might simply refuse to run it. So better if I could invoke this
app in Access.autorun and close down / restart (which is effecitvely
like bootstrapping). Of course I could take the lazy route and just
deny access + point to a batch file: "Your app is out of date, please
run RefreshDB!" - admittedly the cheapest way out.

thanks
Axel

wannall@xxxxxxxxxxxxx wrote:
Thereis no technique you can use to replace an in-use Access mdb.

If your people will be using them locally, you can copy the new bits down
before you open any of them. I still do this with VB (well, VB.NET now) as
a front-end to my access app. The little version checker/copier is so small
that the overhead is negligible, considering the version stay up to date
constantly, and it's capable of checking and copying only exactly what's
needed.

Not to mention that using a vb or vb.net app ahead of the access pieces
opens up all kinds of other possibilities about how you can respond to
command lines.

.

Relevant Pages

  • Re: Good Reasons to port asp.NET VB.NET app to C#
    ... You took the words right out of my mouth, Steve. ... my bosses started looking for a 3D ... myself to create a 3D Terrain-mapping engine using USGS Digital Elevation ... I took my app to the bosses. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Snow Leopard - Lost File Extensions & Custom Icons
    ... this document with the app that created it' behaviour set differently ... open-with code, ... about double-clicking this file opens it in TextWrangler; ... machine that's based on the creator code, on mine it's the default app ...
    (uk.comp.sys.mac)
  • Re: Fastest way to read data to populate combo controls?
    ... The only real reason to ... So there is a way I can read a closed Excel file directly into the ... and the VB app opens that document. ... but keep the Word app object because I will use it later. ...
    (microsoft.public.vb.general.discussion)
  • Re: Relative Hyperlinks
    ... Word can open MHT files it opens, as they're encoded to let IE and Word know what app they were created in, by default (Check to see ... LINKS to the 2007 Office System ...
    (microsoft.public.word.newusers)
  • Re: dwShareMode Failure in CreateFile
    ... multiples of times by multiple instances of the same app. ... My guess, again, is that you're not actually opening the same file every ... the app that opens the file. ...
    (microsoft.public.windowsce.embedded)