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]

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

> I have a compiled file (.mde) and need to replace the file. I use Access 97[color=blue]
> 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.[/color]

The following page at Tony Toews' web site explains the proper way to implement
a split database (do NOT *share* the FE) and also contains a link to his Auto FE
Updater utility to assist in propagating updates to the font end:
http://www.granite.ab.ca/access/splitapp.htm.

--
Bruce M. Thompson, Microsoft Access MVP
bthmpson@mvps.o rg (See the Access FAQ at http://www.mvps.org/access)[color=blue][color=green]
>> NO Email Please. Keep all communications[/color][/color]
within the newsgroups so that all might benefit.<<

[Mike Storr]

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

Really bad idea to have 150 people running the same file. They really should
each have thier own copy that links to the same datasource.

Mike Storr

https://www.veraccess.com

"Danke" <danke@danke.no > wrote in message
news:tM9Yb.516$ EV2.3571@amstwi st00...[color=blue]
> I have a compiled file (.mde) and need to replace the file. I use Access[/color]
97[color=blue]
> 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[/color]
the[color=blue]
> users have the file open. I often need to upgrade with new version of the
> application. I find this problem very difficult.
>
> Helge
>
>[/color]

[NB]

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

Sigh ...
150 users relying on such a system.

Now after you learn how to properly deploy a multi-user app, check
this out

http://www.databasejournal.com/features/msaccess/article.php/3286111

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

I used to update frontends by Tony's free utility at

http://www.granite.ab.ca/access/autofe.htm

but now find Danny's approach better

To kick users out of the database for back-end maintenance, read this

http://groups.google.com.au/groups?hl=en&lr=&ie=UTF-8&selm=77u7um%24di8%241%40esinet2.esinet.net

NB

[Tony Toews]

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

nickbose@lycos. com (NB) wrote:
[color=blue]
>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[/color]

Nice article. Thanks. I've added a link to my Auto FE Updater.
[color=blue]
>I used to update frontends by Tony's free utility at
>http://www.granite.ab.ca/access/autofe.htm
>but now find Danny's approach better[/color]

Why? Because it's all built in Access? Or my utility is a bit quirky to figure out
and get running?
[color=blue]
>To kick users out of the database for back-end maintenance, read this
>http://groups.google.com.au/groups?h...et2.esinet.net[/color]

Yeah, that'd work but it's rather abrupt. One thing to watch out for is that you
have to ensure the timer form is off when you're in VBA code. Otherwise the wrong
item when using Intellisense will kick in prematurely.

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

[NB]

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

> Why? Because it's all built in Access? Or my utility is a bit quirky to figure out[color=blue]
> and get running?[/color]

It's not very easy to get it work at first try. But I did manage and
it worked beautifully. And you're right, I prefer Danny's as it allows
me to easily customize and add some flavours to it.

[color=blue]
> Yeah, that'd work but it's rather abrupt. One thing to watch out for is that you
> have to ensure the timer form is off when you're in VBA code. Otherwise the wrong
> item when using Intellisense will kick in prematurely.
>
> Tony[/color]

I always politely pop up a count down form telling users that they are
being logged off in ... seconds (either due to inactivity or
maintenance work). When it's due to inactivity, the pop-up form give
user a chance to cancel the logoff (but not when it's for maintenance
work).

That timer form is really very annoying when you're in the VB editor.
I bypass it whenever I need to code something.

And Tony, your site is great. I've learnt so much there.

NB

[David W. Fenton]

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

Tony Toews <ttoews@teluspl anet.net> wrote in
news:5kt5301ukn r74j85v9odkdai3 5sgc3ls2m@4ax.c om:
[color=blue]
> nickbose@lycos. com (NB) wrote:[/color]
[color=blue][color=green]
>>I used to update frontends by Tony's free utility at
>>http://www.granite.ab.ca/access/autofe.htm
>>but now find Danny's approach better[/color]
>
> Why? Because it's all built in Access? Or my utility is a bit
> quirky to figure out and get running?[/color]

Well, it solves the issue with your updater of having to store the
MSAccess path in your updater's INI file when you are using
something other than the default workgroup.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Tony Toews]

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

"David W. Fenton" <dXXXfenton@bwa y.net.invalid> wrote:
[color=blue]
>Well, it solves the issue with your updater of having to store the
>MSAccess path in your updater's INI file when you are using
>something other than the default workgroup.[/color]

Ah, now that's a very good point. I've lived with some limitations for so long that
I can't see outside the box.

So a very useful addition then would be for it to do either of the following:
1) use whatever version of Access is associated with the mdb file extension
or
2) use a specific version of Access locatable by using the registry keys such as
SOFTWARE\Micros oft\Office\8.0\ Access\BinDirPa th
SOFTWARE\Micros oft\Access Runtime\8.0
or simlar

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

[Tony Toews]

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

nickbose@lycos. com (NB) wrote:
[color=blue][color=green]
>> Why? Because it's all built in Access? Or my utility is a bit quirky to figure out
>> and get running?[/color]
>
>It's not very easy to get it work at first try.[/color]

Agreed. I figure if I make some simple changes to the names of the lines in the INI
file it will become much easier to understand the first time. And save a lot of
frustration.

Lines such as
SourceDirectory =z:\your product\Server FE directory
TargetDirectory =c:\Workstation FE directory
StartupFile=You r FE name.mde
[color=blue]
>But I did manage and
>it worked beautifully. And you're right, I prefer Danny's as it allows
>me to easily customize and add some flavours to it.[/color]

Understandable.
[color=blue]
>That timer form is really very annoying when you're in the VB editor.
>I bypass it whenever I need to code something.[/color]

What I do is I only ship MDEs to my users,etc. So on that hidden form with the timer
I have it check for if it's an MDE or not. If an MDE then I turn the timer on.
[color=blue]
>And Tony, your site is great. I've learnt so much there.[/color]

Thanks for the comments. Makes the effort worthwhile.

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

[David W. Fenton]

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

Tony Toews <ttoews@teluspl anet.net> wrote in
news:3mi730tg1u otd182s6r3fg7b2 pm2nfuodp@4ax.c om:
[color=blue]
> "David W. Fenton" <dXXXfenton@bwa y.net.invalid> wrote:
>[color=green]
>>Well, it solves the issue with your updater of having to store the
>>MSAccess path in your updater's INI file when you are using
>>something other than the default workgroup.[/color]
>
> Ah, now that's a very good point. I've lived with some
> limitations for so long that I can't see outside the box.
>
> So a very useful addition then would be for it to do either of the
> following: 1) use whatever version of Access is associated with
> the mdb file extension
> or
> 2) use a specific version of Access locatable by using the
> registry keys such as
> SOFTWARE\Micros oft\Office\8.0\ Access\BinDirPa th
> SOFTWARE\Micros oft\Access Runtime\8.0 or simlar[/color]

Yep.

Jeremy Wallace uses a batch file with IF EXIST to test for the
existence of the default Office directory, but that doesn't work
very well.

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.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc

[Bruce M. Thompson]

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

> http://www.databasejournal.com/featu...le.php/3286111[color=blue]
>
> It's a solution by Danny Lesandrini, very clean, and all Access-native
> for automatic updating of users' front ends[/color]

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

--
Bruce M. Thompson, Microsoft Access MVP
bthmpson@mvps.o rg (See the Access FAQ at http://www.mvps.org/access)[color=blue][color=green]
>> NO Email Please. Keep all communications[/color][/color]
within the newsgroups so that all might benefit.<<

[Tony Toews]

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

"David W. Fenton" <dXXXfenton@bwa y.net.invalid> wrote:
[color=blue]
>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.[/color]

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