How to replace a .mde file when many users are connected to the file

[Danke]

I have a compiled file (.mde) and need to replace the file. I use Access 97
and SQL-server. I have about 150 users. I have made a shortcut to the
startmenu for this file. Its impossible to replace the file when any of the
users have the file open. I often need to upgrade with new version of the
application. I find this problem very difficult.

Helge

[Bruce M. Thompson]

> http://www.databasejournal.com/featu...le.php/3286111

It's a solution by Danny Lesandrini, very clean, and all Access-native
for automatic updating of users' front ends

I agree with Tony - that's a slick approach. Thanks for posting that url.

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.o rg (See the Access FAQ at http://www.mvps.org/access)

NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<

[Tony Toews]

"David W. Fenton" <dX********@bwa y.net.invalid> wrote:

If your updater could get something from the registry, that would be
helpful. I'd rather it not use the default or guess, but be
something where you could tell it to use A2K or A97 or whatever.

Agreed. That the person doing the configuration should state what version of Access
to use. That said it would be nice if the utility could be configured for multiple
versions of Acces which some folks, such as my client, have installed. Then it would
copy down the appropriate file as required.

Right now they have three INI files and two FE directories. One INI file for A97.
Another INI file for A2000 installed locally. Another INI file for A2000 installed
on the Citrix server. It'd be nice to have that all in one INI file in an coherent
and logical layout. <smile>

Now what I could also do is examine the bytes at the beginning of the MDB/MDE file
and figure out what version of the MDB/MDE really is. But that kind logic is getting
pretty complicated.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm