Auto FE Updater

[Guest]

This question is for Tony Toews but if anyone has an answer please reply back.

I am using the Auto FE updater to update the FE of my database. (Btw thanks for the reply on an earlier post. The utility is great.) Unfortunately the db is on the WAN. I have deployed it using the Terminal Sevices idea. The problem I am having is with the .mdw file. If I don't deploy the app with the .mdw file and leave the .mdw file in the same folder as the backend, opening forms becomes even slower. The app is slow enough already. If the .mdw file is in the same folder as the FE there is a definite improvement in the speed. My code is basically CommandLine=/wrkgrp "W:\Folder\%user%\File.mdw". I get the error message "Microsoft Access couldn't find file 'W:\Folder\%user%\File.mdw'. This file is required for start up." If I specify the path to the backend then this doesn't occur. Obviously it is not recognizing the %user% and is just seeing it as part of the string. Is there anyway to make the utility pull the .mdw file from the user's folder.

 

[Tony Toews]

I am using the Auto FE updater to update the FE of my database. (Btw thanks for the reply on an earlier post. The utility is great.) Unfortunately the db is on the WAN. I have deployed it using the Terminal Sevices idea. The problem I am having is with the .mdw file. If I don't deploy the app with the .mdw file and leave the .mdw file in the same folder as the backend, opening forms becomes even slower. The app is slow enough already.

Have you read the Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm ?

If the .mdw file is in the same folder as the FE there is a definite improvement in the speed. My code is basically CommandLine=/wrkgrp "W:\Folder\%user%\File.mdw". I get the error message "Microsoft Access couldn't find file 'W:\Folder\%user%\File.mdw'. This file is required for start up." If I specify the path to the backend then this doesn't occur. Obviously it is not recognizing the %user% and is just seeing it as part of the string. Is there anyway to make the utility pull the .mdw file from the user's folder.

Ah, I see what you are trying to do. No, the utility does not
currently support %user% in the CommandLine INI line.

Could you send me a separate email? I'll see if I can get to it later
today or tomorrow and make that change as well as a few more. I'll
email you once it's done with a URL.

AFAIK there is a at least one problem with keeping the MDW on the
client workstation. The code which uses the Jet UserRoster won't
work properly anymore. See
http://www.granite.ab.ca/access/corruption/workstation.htm. There
may be other problems with this but I'll let those who know more about
security comment here.

Thanks, 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

 

[Guest]

Hi Tony, afetr you have made changes to the FE Updater, would you post the new version agian in the your web? If possible, I would like to have a copy please.

 

[Tony Toews]

Hi Tony, afetr you have made changes to the FE Updater, would you post the new version agian in the your web? If possible, I would like to have a copy please.

Definitely. I was also going to post an FYI message to the newsgroup.

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