Front End location

[Me!Frustrated = True]

Hello experts.
I was just wondering, I have the front end of my split and secured database
saved in the C:\Documents and Settings\All Users\Desktop folder because I
think it makes it easier for me to update each one. Is there any detriment
to putting it there, rather than in each individual user's \Desktop folder on
each machine?

TIA,
Mike

 

[Tony Toews [MVP]]

I was just wondering, I have the front end of my split and secured database
saved in the C:\Documents and Settings\All Users\Desktop folder because I
think it makes it easier for me to update each one. Is there any detriment
to putting it there, rather than in each individual user's \Desktop folder on
each machine?

One comment is that the LDB file might show up on the users desktop as
it is created. Thus causing some confusion on the users part.

In my opinion the best location for the FE is the users Application
Data folder - %appdata%\<app name>\. Which maps to
C:\Documents and Settings\ttoews\Local Settings\Application Data\<app
name>
in Windows XP. Thus it's on the users local machine but unless they
turn on hidden files and folder in Windows Explorer they can't see it.

Also note that Windows Vista is read only access to C:\Documents and
Settings\All Users

As far as updating the app I specifically created the free Auto FE
Updater utility so that I could make changes to the FE MDE as often as
I wanted and be quite confident that the next time someone went to run
the app that it would pull in the latest version. For more info on
the errors or the Auto FE Updater utility see the free Auto FE Updater
utility at http://www.granite.ab.ca/access/autofe.htm at my website to
keep the FE on each PC up to date.

Tony

 

[Me!Frustrated = True]

Thanks Tony for your prompt reply.
I will check out your FE Updater. Other than each user needing 'write'
permission for the Application Data folder, is there anything else I would
need to do? I keep the front end in its own folder, along with a .bmp file
and a readme file used by the database. Can your utility update/copy that
entire folder from the source, or only the mdb file?

 

[Tony Toews [MVP]]

I will check out your FE Updater. Other than each user needing 'write'
permission for the Application Data folder, is there anything else I would
need to do?

No. The Auto FE Updater will create the appropriate subfolder in the
%appdata% folder, copy files across, and create shortcuts.

I keep the front end in its own folder, along with a .bmp file
and a readme file used by the database. Can your utility update/copy that
entire folder from the source, or only the mdb file?

Entire folder but not subfolders.

Tony

 

[Me!Frustrated = True]

Thanks very much for your help, Tony. I'll try it!